stop users from deleting rows
 

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_

stop users from deleting rows
 

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:

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_

--

Dave Peterson

stop users from deleting rows
 

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

"Dave Peterson" wrote:

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:

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_

--

Dave Peterson