Assuming that the security setting on the computer is set to Low
or Medium, it is possible that the Application.EnableEvents
somehow got set to False (typically by a poorly coded macro that
switches it to False and neglects to set it back to True). To
test this, go to the computer having the problem, open the VBA
Editor (ALT+F11) then open the Immediate Window (CTRL+G) and type
the following and press the Enter key:

?Application.EnableEvents

If this returns False, events such as Workbook_Open will not
run. Change it to true by entering the following code in the
Immediate Window and pressing Enter:

Application.EnableEvents = True


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com





"mrice"
wrote in message
...

Has anybody experienced Workbook_Open macros sometimes not
running on
one user's computer when they work fine for other users? If so,
is
there a fix?

Martin


--
mrice

Reserach Scientist with many years of spreadsheet development
experience
------------------------------------------------------------------------
mrice's Profile:
http://www.excelforum.com/member.php...o&userid=10931
View this thread:
http://www.excelforum.com/showthread...hreadid=536068