Workbook_Open macro not running

M

mrice

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
 
P

Paul B

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
 
C

Chip Pearson

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" <[email protected]>
wrote in message
news:[email protected]...
 
Top