Unprotecting a menu bar

D

David

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

David
 
B

Bob Phillips

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)
 
T

Tom Ogilvy

Commandbars("Worksheet Menu Bar").Protection = msoBarNoChangeVisible

sets it back to the default.
 
Top