software

Hi,

is there a way to stop users from deleting rows? I need them to be able to
insert, change but not delete.thx
wAyne_

If everyone is using xl2002 , you can set those requirements when you protect
the sheet.

If anyone is using less than xl2002, then I think you could protect the sheet,
but give the users a macro that would only do what you want. Your macro would
unprotect the sheet, do the work and reprotect the sheet.

But there are lots of things that can not be done on protected sheets.

wAyne wrote:
gt;
gt; Hi,
gt;
gt; is there a way to stop users from deleting rows? I need them to be able to
gt; insert, change but not delete.
gt;
gt; thx
gt; wAyne_

--

Dave Peterson

Not using XL2002 .. have it on some computers but not all... damn.
Oh well -- thanks for the info anyway -- I'll just hope they can follow
instructions.

wAyne

quot;Dave Petersonquot; wrote:

gt; If everyone is using xl2002 , you can set those requirements when you protect
gt; the sheet.
gt;
gt; If anyone is using less than xl2002, then I think you could protect the sheet,
gt; but give the users a macro that would only do what you want. Your macro would
gt; unprotect the sheet, do the work and reprotect the sheet.
gt;
gt; But there are lots of things that can not be done on protected sheets.
gt;
gt; wAyne wrote:
gt; gt;
gt; gt; Hi,
gt; gt;
gt; gt; is there a way to stop users from deleting rows? I need them to be able to
gt; gt; insert, change but not delete.
gt; gt;
gt; gt; thx
gt; gt; wAyne_
gt;
gt; --
gt;
gt; Dave Peterson
gt;