Prevent insert/delete rows - sheet code

  • Thread starter Thread starter Hennie Neuhoff
  • Start date Start date
H

Hennie Neuhoff

Hi Guys
Excel 2003
I want to prevent the user from inserting/delete rows on certain sheets
in the workbook. On this site I got an idea to display a message
[Worksheet_Activate] which works fine, but that's not really what
I want. The problem is these messages appears when I run other code
like "Sort sheets by name" etc..
I guess the " Worksheet_Activate" should be replaced by something like
Worksheet_change.

I don't know how to do this.

As always, any assistance will be appreciated.
 
Select menu item Tools -> Protection -> Protect Sheet.

Check the boxes against those things you want the user to be able to do and
leave the others unchecked.

Enter a password. (You will be prompted to enter it again.)

WARNING: Don't forget the password.
 
Forgot to say that before implementing my previous suggestion you may want to
select all cells that you want the user to be able to edit then select menu
item Format -> Cells - Protection tab and uncheck Locked.
 
Back
Top