Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Prevent user from inserting sheet via "CTRL-F11"
Is there a way to prevent a user from inserting a sheet using CTRL-F11?
I have already disabled Insert-Worksheet as well as the right-click insert functionality, but I know the users know this key combo to insert a sheet as well. Thanks so much!! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Prevent user from inserting sheet via "CTRL-F11"
How about protecting the structure of the workbook under
Tools=Protection=Protect Workbook= select at least structure. of couse this would not allow moving the sheets either. -- Regards, Tom Ogilvy " wrote: Is there a way to prevent a user from inserting a sheet using CTRL-F11? I have already disabled Insert-Worksheet as well as the right-click insert functionality, but I know the users know this key combo to insert a sheet as well. Thanks so much!! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Prevent user from inserting sheet via "CTRL-F11"
I did try this and it affected the functionality between this workbook
and another which both have heavy backend macros. Thanks for the suggestion though!! Tom Ogilvy wrote: How about protecting the structure of the workbook under Tools=Protection=Protect Workbook= select at least structure. of couse this would not allow moving the sheets either. -- Regards, Tom Ogilvy " wrote: Is there a way to prevent a user from inserting a sheet using CTRL-F11? I have already disabled Insert-Worksheet as well as the right-click insert functionality, but I know the users know this key combo to insert a sheet as well. Thanks so much!! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Prevent user from inserting sheet via "CTRL-F11"
found the answer in another thread if anyone is interested...
http://groups.google.com/group/micro...a6efd11b37e7f0 wrote: I did try this and it affected the functionality between this workbook and another which both have heavy backend macros. Thanks for the suggestion though!! Tom Ogilvy wrote: How about protecting the structure of the workbook under Tools=Protection=Protect Workbook= select at least structure. of couse this would not allow moving the sheets either. -- Regards, Tom Ogilvy " wrote: Is there a way to prevent a user from inserting a sheet using CTRL-F11? I have already disabled Insert-Worksheet as well as the right-click insert functionality, but I know the users know this key combo to insert a sheet as well. Thanks so much!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Cannot shift objects off sheet" in Excel when inserting row/col? | Excel Worksheet Functions | |||
Why does "cannot shift objects off sheet" prevent row insertion? | Excel Discussion (Misc queries) | |||
In Excel 2003 is there a way to prevent "Save As" and "Print"? | Excel Discussion (Misc queries) | |||
Prevent code in "Sheet Activate" from running when sheet made visible from other macr | Excel Programming | |||
Prevent non "validation" user entry | Excel Programming |