| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Question Inserting Rows & Columns | New Users to Excel | |||
| Inserting columns & rows in worksheets | Excel Worksheet Functions | |||
| Static formula when inserting new rows/columns? | Excel Discussion (Misc queries) | |||
| inserting columns within certain rows only | Excel Discussion (Misc queries) | |||
| Prevent unhide of rows/columns w/out worksheet protection? | Excel Discussion (Misc queries) | |||
Hybrid Mode
