Prevent Inserting rows/columns

J

Jase

I was wondering if their is a way to prevent a user from inserting rows or
cells on worksheet or to send them a message warning if they try to?
 
D

Dave Peterson

You could protect the worksheet

In xl2003, it's tools|Protection|protect sheet
 
J

Jase

I am looking for more protection then just protecting it. I was hoping maybe
a message box if someone tried to insert.
 
J

johnny

I am looking for more protection then just protecting it. I was hoping maybe
a message box if someone tried to insert.
Click to expand...

You can disable the menu item :
Application.CommandBars("Worksheet Menu
Bar").Controls("Insert").Controls("Columns").Enabled = False
Application.CommandBars("Worksheet Menu
Bar").Controls("Insert").Controls("Rows").Enabled = False

Johnny.
 
Top