Unprotecting a menu bar

  • Thread starter Thread starter David
  • Start date Start date
D

David

How can I unprotect a menu bar (e.g. 'Worksheet Menu Bar')
I have previously protected using 'MenuBarName.Protection'?

David
 
David,

Application.CommandBars("Worksheet Menu Bar").Protection =
msoBarNoProtection


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Commandbars("Worksheet Menu Bar").Protection = msoBarNoChangeVisible

sets it back to the default.
 
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

Macro to prompt for password to unprotect worksheets 2
Copying in sheet with protection with the use of a macro 5
Excel Protection 2
Unprotect Workbook with Function 3
Disable Tools > Protection 3
Custom Menu Bar in Excel 2007 21
How to bypass password when pasting FROM a protected workbook 3
Protecting worksheet. 1

Back
Top