Just as a side note, the Auto_Open procedure (indeed all the Auto
procedures) does not run if the workbook is opened via code. For
example,
Dim WB As Workbook
Set WB = Workbooks.Open("C:\Test.xls")
The Auto_Open proc of C:\Test.xls will not be executed. You must call
it yourself if it needs to run:
WB.RunAutoMacros xlAutoOpen
Cordially,
Chip Pearson
Microsoft MVP 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
[email on web site]
On Sat, 23 Jan 2010 14:05:25 -0800 (PST), jeh
wrote:
Thanks Dave. Problem fixed. The auto-open macro does run as soon
once Macros are enabled. I was fooled by the worksheet appearing
before I could enable macros, the opposite of the sequence in xl2k.
John.
On Jan 24, 1:07*am, Dave Peterson wrote:
I don't use win7, but I've never experienced any problems with my auto_open or
workbook_open procedures that were written in xl97 to xl2003 when opened in
xl2007.
I allow macros to run and they fire successfully.
Maybe it's the macro itself????
Could you add a
msgbox "Running"
as the first line inside the code--just to see if the code actually starts???
jeh wrote:
For years I've been using an Excel 2000 workbook (under Win XP)
containing several macros, one of which is auto-opened at launch. *(It
performs necessary date checks). *Security has been set so that before
the workbook opens I get a warning text box asking me if I want to
enable or disable macros.
I've just ported the workbook to Office 2007 in a new computer running
Win 7 Pro. *With this system I find that when the workbook opens (in
compatibilty mode), the current worksheet and the warning bar about
macros appear simultaneously. *I can accept or reject macro operation
as I wish, but even if I accept it the auto-open macro hasn't run. Any
ideas how to get round this? *I'm in unfamiliar territory with no
previous experience of Win 7 and not much of Office 2007. *Have I just
missed something simple?
I can't use self-signed certificates because the workbook will be used
on more than one computer.
TIA * John
--
Dave Peterson- Hide quoted text -
- Show quoted text -