ExcelBanter - Unprotecting a menu bar

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Unprotecting a menu bar (https://www.excelbanter.com/excel-programming/278203-unprotecting-menu-bar.html)

David

Unprotecting a menu bar

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

David

Bob Phillips[_5_]

Unprotecting a menu bar

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

Tom Ogilvy

Unprotecting a menu bar

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

sets it back to the default.

--
Regards,
Tom Ogilvy

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

David

All times are GMT +1. The time now is 08:57 AM.