workbook_open not being called when I open the excel file
 

I added some code in the workbook_Open() but the when the user opens
the excel file, there is evidence that the workbook_Open() not being
called (form not showing, cells not initializing). He has Excel 2003
Sp1. Does anyone know how could this happen?

workbook_open not being called when I open the excel file
 

When Excel prompts him, if he selects "Disable Macros" then Excel will
not initiate any commands in the Workbook_Open command. The same goes
if he has his security set to high in the settings. If that's not the
problem, might be a problem with the code. But would have to see it to
know whether it is or not.


--
dok112
------------------------------------------------------------------------
dok112's Profile: http://www.excelforum.com/member.php...o&userid=10581
View this thread: http://www.excelforum.com/showthread...hreadid=531111

workbook_open not being called when I open the excel file
 

Hi Hany,
One possible cause is the macro security level is set at "Very High".
When security is at this level the Workbook_Open macro is ignored and
Excel gives no indication to the user that this is the case.
Security is adjusted by going ToolsMacroSecurity...
Medium is the safe choice. The User is given the choice of Enabling or
Disabling macros.

Ken Johnson

workbook_open not being called when I open the excel file
 

Try:

Sub auto_open ()

End sub

Gabor

"Hany" schrieb im Newsbeitrag
oups.com...
I added some code in the workbook_Open() but the when the user opens
the excel file, there is evidence that the workbook_Open() not being
called (form not showing, cells not initializing). He has Excel 2003
Sp1. Does anyone know how could this happen?