Adding Menus through the VBA editor?
Posted by Peter Glass on August 25, 1999 7:20 PM
In Excel 95 there was a nifty icon in the VBA module pages that allowed you to edit the menu bar and add menus - it was workbook specific, so that when you opened that workbook the menus changed to what you had selected.
Does this feature exist in Excel 97? I can't find the icon. Or do I have to write an Auto_Open macro every time?
Thanks for your help!
Peter
Posted by Ivan Moala on August 26, 1999 4:57 AM
Peter,
I think this option is not avail.
You will have to create a commandbar that loads
in as you suggested for your workbook via the;
Private Sub Workbook_Open()
& delete it when closing down unless you want
the commandbar buttons avail.
Ivan
Posted by Peter Glass on August 26, 1999 11:29 PM
Thanks Ivan....
Thanks anyway for your help Ivan. Since you seem to be the Mr Excel Guru of Guru's, can you give Mr Gates a call and tell him to stop taking away such useful features? ;)
Peter
Posted by Ivan Moala on August 27, 1999 5:28 AM
Re: Thanks Ivan....
:
Thanks Peter
But there are a lot better then me ;)
Have a look @ Chris's answers, he has some
good routines.
regards
Ivan
Posted by bill.roberts on March 06, 2000 1:33 PM
Re: Thanks Ivan....
Hey!
Don't forget CELIA!!
bill
