Prevent Inserting rows/columns

  • Thread starter Thread starter Jase
  • Start date Start date
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?
 
You could protect the worksheet

In xl2003, it's tools|Protection|protect sheet
 
I am looking for more protection then just protecting it. I was hoping maybe
a message box if someone tried to insert.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert Worksheet 2
VBA - retrieve data on last create named range from previous inserted named range 0
Insert blank row after change in cell value not working. 1
Excel-Adding rows to master sheet that will be inserted on following worksheets 1
Prevent Insert Row and Delete Row from Menu 4
Adding more than 65,536 rows in Excel 2007 5
Unable to Insert Columns 5
Windows 7 Problem with Services 4

Back
Top