Re: How to run auto-open macro in Excel 2007?


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
<John.Humble@xxxxxxxxxxx> 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 <peter...@xxxxxxxxxxxxxxxx> 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 -
.

Relevant Pages

  • Re: How do I keep Hidden Columns / Rows from being Unhidden / Refe
    ... the Workbook with the hidden ... open WkbkB if its Macros are disabled, WkbkA's Macro will force Macros to be ... WkbkB's Macros will disallow editing except via Macro options. ... False, b) calls Application.SendKeys "e", c) opens ...
    (microsoft.public.excel.programming)
  • Re: How do I keep Hidden Columns / Rows from being Unhidden / Refe
    ... open WkbkB if its Macros are disabled, WkbkA's Macro will force Macros to ... references Hidden Cells in their Workbook Open Event). ... WkbkB's Macros will disallow editing except via Macro options. ...
    (microsoft.public.excel.programming)
  • Re: How do I keep Hidden Columns / Rows from being Unhidden / Refe
    ... I think it's a mistake if you think that your suggestions will protect any ... Excel just isn't made for this kind of thing--no matter how hard you try. ... the Workbook with the hidden ... open WkbkB if its Macros are disabled, WkbkA's Macro will force Macros to be ...
    (microsoft.public.excel.programming)
  • RE: New clue! Open/Close other workbooks with VBA;
    ... You can also put a stop instruction in the workbook that is failing to ... isolate any problems with workbook open macros. ... File 1 opens and closes as expected. ... Dim secAutomation As MsoAutomationSecurity ...
    (microsoft.public.excel.programming)
  • RE: New clue! Open/Close other workbooks with VBA;
    ... You can also put a stop instruction in the workbook that is failing to ... isolate any problems with workbook open macros. ... File 1 opens and closes as expected. ... Dim secAutomation As MsoAutomationSecurity ...
    (microsoft.public.excel.programming)