View Single Post
  #5   Report Post  
Ron de Bruin
 
Posts: n/a
Default

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