View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Otto Moehrbach[_2_] Otto Moehrbach[_2_] is offline
external usenet poster
 
Posts: 1,071
Default 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