D David Sep 28, 2003 #1 How can I unprotect a menu bar (e.g. 'Worksheet Menu Bar') I have previously protected using 'MenuBarName.Protection'? David
How can I unprotect a menu bar (e.g. 'Worksheet Menu Bar') I have previously protected using 'MenuBarName.Protection'? David
B Bob Phillips Sep 28, 2003 #2 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, 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 Sep 28, 2003 #3 Commandbars("Worksheet Menu Bar").Protection = msoBarNoChangeVisible sets it back to the default.
