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 is new,
Private Sub Workbook_Activate()
Private Sub Workbook_BeforeClose(Cancel As Boolean)
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?
*** Sent via Developersdex http://www.yqcomputer.com/
Don't just participate in USENET...get rewarded for it!