Workbook_Open macro not running
 

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

Workbook_Open macro not running
 

Martin, have you checked the security settings on the computer that it want
run on?

To change the security settings go to tools, macro, security, security level
and set it to medium
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003


"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

Workbook_Open macro not running
 

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