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)

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

David