Prevent user from inserting sheet via "CTRL-F11"

  • Thread starter Thread starter korrin.anderson
  • Start date Start date
K

korrin.anderson

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!!
 
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.
 
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!!
 
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

Prevent user from Inserting new worksheet 4
prevent a user from adding any sheet in a workbook 2
preventing referencing hidden cell 3
Selecting data from multiple worksheets 5
VBA - retrieve data on last create named range from previous inserted named range 0
Prevent insert/delete rows - sheet code 2
prevent users from adding sheets / charts 6
Keeping formulas on an insert 1

Back
Top