Disable Items in Menubar

C

cassy01

Hi is it possible to disble some of the menus in the menubar ???

i have created a menubar of my own for a specific workbook so when it
opens it enables my custom menubar but still shows the default one.

any way of getting rid of the default menu then putting it back when it
closes ??

thaks
 
B

Bob Phillips

Application.Commandbars(1).Controls("Tools").Enabled = False

and set to True after

--

HTH

RP
(remove nothere from the email address if mailing direct)
 

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

Top