Prevent Inserting rows/columns
 

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?

Prevent Inserting rows/columns
 

You could protect the worksheet

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

Jase wrote:

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?

--

Dave Peterson

Prevent Inserting rows/columns
 

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

"Dave Peterson" wrote:

You could protect the worksheet

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

Jase wrote:

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?

--

Dave Peterson

Prevent Inserting rows/columns
 

On Apr 15, 1:25 pm, Jase wrote:
I am looking for more protection then just protecting it. I was hoping maybe
a message box if someone tried to insert.

"Dave Peterson" wrote:
You could protect the worksheet

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

Jase wrote:

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?

--

Dave Peterson

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

Johnny.