Remove custom menu

[Guest]

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

 

[Ron de Bruin]

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

 

[Dave Peterson]

Ron,

I think you have an extra hypen in your link.

http://www.cpearson.com/excel/events.htm

 

[Ron de Bruin]

Thanks Dave

 

[Ron de Bruin]

Hi Dave

Strange that you don't see the - in the thread
I copy/paste Chip's link from a old thread (Google)

 

[Dave Peterson]

I see it in this thread--using Netscape 4.79 as my newsreader.