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