software

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

Use this two events in the Thisworkbook module.

Private Sub Workbook_Activate()

End Sub

Private Sub Workbook_Deactivate()

End SubRead more about events on Chip Pearson's site.
www.cpearson.com/excel/events.htm
--
Regards Ron de Bruin
www.rondebruin.nlquot;Graham Fquot; gt; wrote in message ...
gt; Hi Group, My problem is I have a custom menubar which is written everytime
gt; the workbook is open with the Workbook open event and deleted when the
gt; workbook is closed with the workbook BeforeClose event. The problem is that
gt; when I have more than one instance of the workbook open and then I close one,
gt; the custom menu bar disappears and the default Excel one reappears, as per
gt; the workbook close event. I am trying to find out if any event is triggered
gt; on the workbook that remains open, so that I can call the menubar routine to
gt; redraw the custom menubar. I have tried most, if not all without success,
gt; please help. Many thanks Graham