ThisWorkbook.Protect

  • Thread starter Thread starter Jack Sheet
  • Start date Start date
J

Jack Sheet

Am I right in saying that the UserInterfaceOnly setting can only be applied
at Worksheet level, not Workbook level?
So I have to unprotect the workbook at the start of each macro and then
protect it again at the end? Seems a bit of an oversight, if so.
 
I see UserInterfaceOnly in VBA's help for worksheets--not for workbooks.

But if you've protected the workbook's structure and want to add/delete/rename a
sheet, then yep, you have to unprotect/do the work/reprotect.

Did you really protect the workbook? I protect worksheets much more often than
the workbook.
 
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

Unprotect Workbook with Function 3
Problem with Workbook Protection Excel 2007 1
Problem protecting workbook 4
Excel Protection 2
Controlling worksheet protection via VBA 0
Macro code mod - add tabs/apply to entire workbook 2
Macro doesn't work when Sheets are protected UserInterfaceOnly 1
Programatically filter a protected shared workbook 4

Back
Top