Many thanks for helpful replies, Bob and Joel. I'll investigate further but
my immediate reaction is that I'm pretty sure I don't have any event
disabling code anywhere associated with this workbook. All my workbook_open
event does is to call a procedure to build a new main toolbar and to hide the
standard and formatting bars. It also builds my popup toolbars ready for
showing on specific sheet's RightClick events.
--
David Stevenson, UK


"Joel" wrote:

I suspect there is a open event macro that ran and failed. the macro probaly
disabled event when it opened and then when reaching the error didn't
re-enable the events.

"David" wrote:

On opening one of my workbooks this morning I found that all the worksheet
events were inactive (BeforeRightClick, Activate etc). As a consequence my
popup menus wouldn't appear (BeforeRightClick) neither would toolbars appear
and disappear in response to the Activate and Deactivate events. After I
closed the workbook and reopened it, there was no change but things got back
to normal after I had shut down Excel and reopened it. All is now well but I
am puzzled what might have caused the problem. ANy suggestions?
--
David Stevenson, UK