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