|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 8th, 2005, 03:52 PM
|
|||
|
|||
Remove custom menu
I created a custom menu that loads when a workbook is
opened. This menu is needed only for this one workbook. How, and where, do I write the code to remove the menu when the workbook is closed? TIA 
|
|
#2
March 8th, 2005, 04:09 PM
|
|||
|
|||
|
Hi
Use this events in the thisworkbook module Private Sub Workbook_Activate() End Sub Private Sub Workbook_Deactivate() End Sub Read Chip Pearson's site about Events http://www.cpearson.com/excel/*events.htm -- Regards Ron de Bruin http://www.rondebruin.nl wrote in message ... I created a custom menu that loads when a workbook is opened. This menu is needed only for this one workbook. How, and where, do I write the code to remove the menu when the workbook is closed? TIA
|
|
#3
March 8th, 2005, 04:25 PM
|
|||
|
|||
|
Ron,
I think you have an extra hypen in your link. http://www.cpearson.com/excel/events.htm Ron de Bruin wrote: Hi Use this events in the thisworkbook module Private Sub Workbook_Activate() End Sub Private Sub Workbook_Deactivate() End Sub Read Chip Pearson's site about Events http://www.cpearson.com/excel/*events.htm -- Regards Ron de Bruin http://www.rondebruin.nl wrote in message ... I created a custom menu that loads when a workbook is opened. This menu is needed only for this one workbook. How, and where, do I write the code to remove the menu when the workbook is closed? TIA -- Dave Peterson
|
|
#4
March 8th, 2005, 04:29 PM
|
|||
|
|||
|
Thanks Dave
-- Regards Ron de Bruin http://www.rondebruin.nl "Dave Peterson" wrote in message ... Ron, I think you have an extra hypen in your link. http://www.cpearson.com/excel/events.htm Ron de Bruin wrote: Hi Use this events in the thisworkbook module Private Sub Workbook_Activate() End Sub Private Sub Workbook_Deactivate() End Sub Read Chip Pearson's site about Events http://www.cpearson.com/excel/*events.htm -- Regards Ron de Bruin http://www.rondebruin.nl wrote in message ... I created a custom menu that loads when a workbook is opened. This menu is needed only for this one workbook. How, and where, do I write the code to remove the menu when the workbook is closed? TIA -- Dave Peterson
|
|
#5
March 8th, 2005, 04:34 PM
|
|||
|
|||
|
Hi Dave
Strange that you don't see the - in the thread I copy/paste Chip's link from a old thread (Google) -- Regards Ron de Bruin http://www.rondebruin.nl "Dave Peterson" wrote in message ... Ron, I think you have an extra hypen in your link. http://www.cpearson.com/excel/events.htm Ron de Bruin wrote: Hi Use this events in the thisworkbook module Private Sub Workbook_Activate() End Sub Private Sub Workbook_Deactivate() End Sub Read Chip Pearson's site about Events http://www.cpearson.com/excel/*events.htm -- Regards Ron de Bruin http://www.rondebruin.nl wrote in message ... I created a custom menu that loads when a workbook is opened. This menu is needed only for this one workbook. How, and where, do I write the code to remove the menu when the workbook is closed? TIA -- Dave Peterson
|
|
#6
March 8th, 2005, 05:06 PM
|
|||
|
|||
|
I see it in this thread--using Netscape 4.79 as my newsreader.
Ron de Bruin wrote: Hi Dave Strange that you don't see the - in the thread I copy/paste Chip's link from a old thread (Google) -- Regards Ron de Bruin http://www.rondebruin.nl "Dave Peterson" wrote in message ... Ron, I think you have an extra hypen in your link. http://www.cpearson.com/excel/events.htm Ron de Bruin wrote: Hi Use this events in the thisworkbook module Private Sub Workbook_Activate() End Sub Private Sub Workbook_Deactivate() End Sub Read Chip Pearson's site about Events http://www.cpearson.com/excel/*events.htm -- Regards Ron de Bruin http://www.rondebruin.nl wrote in message ... I created a custom menu that loads when a workbook is opened. This menu is needed only for this one workbook. How, and where, do I write the code to remove the menu when the workbook is closed? TIA -- Dave Peterson -- Dave Peterson
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Custom Menu return to Excel Menu | VetcalcReport | Worksheet Functions | 1 | August 2nd, 2004 03:02 PM |
| How to remove items from drop down menu | hsheah | General Discussion | 4 | June 22nd, 2004 07:18 AM |
| office 2000 remove tools | bud | Setup, Installing & Configuration | 1 | May 27th, 2004 10:40 AM |
Linear Mode
