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.

--
Regards,

OssieMac


"Hennie Neuhoff" wrote:

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.

--
HJN