Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
custom menus in excel
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
custom menus in excel
In the application workbook, you can use the Activate and Deactivate events in the ThisWorkbook code module to make the menus hidden when your workbook is deactivated (user switches to another workbook) and then restore their visibility when the workbook is activated (user returns to your workbook). ' In the ThisWorkbook code module: Private Sub Workbook_Activate() ' code to make menus/commandbars visible End Sub Private Sub Workbook_Deactivate() ' code to make menus/commandbars hidden End Sub Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group, 1998 - 2009 Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Thu, 27 Aug 2009 11:50:02 -0700, siansun wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
custom menus in excel
Great! Thanks for the help.
"Chip Pearson" wrote: In the application workbook, you can use the Activate and Deactivate events in the ThisWorkbook code module to make the menus hidden when your workbook is deactivated (user switches to another workbook) and then restore their visibility when the workbook is activated (user returns to your workbook). ' In the ThisWorkbook code module: Private Sub Workbook_Activate() ' code to make menus/commandbars visible End Sub Private Sub Workbook_Deactivate() ' code to make menus/commandbars hidden End Sub Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group, 1998 - 2009 Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Thu, 27 Aug 2009 11:50:02 -0700, siansun wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can you set up custom menus in Excel 2007? | Excel Programming | |||
Custom Menus With Excel 2007 | Excel Programming | |||
Adding custom menus to Excel ???? | Excel Programming | |||
Excel & Custom Menus | Excel Programming | |||
Excel.xlb and Custom Menus | Excel Programming |