Hi Ron:

Thank you for your prompt response, very much appreciated.
In terms of what you had suggested, I doubt that might be the cause.
Here's what I had done after first email, I added a call to
workbook_activate() method. see below...

============================
Private Sub Workbook_Open()
'Call the 'sub' so code is only modified in one place
Workbook_Activate
End Sub

'Workbook_activate is new,
Private Sub Workbook_Activate()
Call AddCustomMenu
Call Toolbar_ON
End Sub

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Call RemoveCustomMenu
Call Toolbar_OFF
End Sub
=================================

Since all the workbook is opened, and when user closes one of the
workbook, it closes and remove the menu, and that remove affect rest of
the open workbook and when user activates the other workbook, there is
no action in Workbook_activate() method before. Here I am adding it,
hopefully it will work when they actives the workbook.

Do you think this will fix the problem?

Thanks
Peter


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!