Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Running Macro minimises window | Excel Discussion (Misc queries) | |||
Macro Help In Excel | Excel Discussion (Misc queries) | |||
Macro running when a cell is exited | Excel Discussion (Misc queries) | |||
Macro running problem | Excel Discussion (Misc queries) | |||
Running VBA Macro | Excel Discussion (Misc queries) |