custom menus in excel
Use a Workbook_Activate macro to create the custom menus, and a
Workbook_Deactivate macro to remove the custom menus. That way the custom
menus appear only if that workbook is the active workbook. HTH Otto
"siansun" wrote in message
...
I have created an excel application with mostly custom menus using vba
code.
The problem is that when the application is open, if i try to open a
regular
excel file it also opens showing only the custom menus. is there a way to
(programmatically) get around this problem? and would i be able to do this
in
vba code for the application containing the custom menus?
thanks
|