MenuBar & Event problems

[Graham F]

Hi Group, My problem is I have a custom menubar which is written everytime
the workbook is open with the Workbook open event and deleted when the
workbook is closed with the workbook BeforeClose event. The problem is that
when I have more than one instance of the workbook open and then I close one,
the custom menu bar disappears and the default Excel one reappears, as per
the workbook close event. I am trying to find out if any event is triggered
on the workbook that remains open, so that I can call the menubar routine to
redraw the custom menubar. I have tried most, if not all without success,
please help. Many thanks Graham

 

[Ron de Bruin]

Use this two events in the Thisworkbook module.

Private Sub Workbook_Activate()

End Sub

Private Sub Workbook_Deactivate()

End Sub


Read more about events on Chip Pearson's site.
http://www.cpearson.com/excel/events.htm