No Auto_Open macro?

Question

Hello -

I'm migrating a workbook and associated macros from Windows to Mac.  The Auto_Open macro doesn't run when the workbook is opened.  Has that feature been removed from this version or have I done something dumb?

Thanks!

Tim

Answer 1

Auto_Open() will work only if it's in a regular (non-workbook or worksheet class, i.e., ThisWorkbook, or Sheet1, Sheet2, etc.) module.

Otherwise, use the Workbook_Open() event macro (as you do above) in the ThisWorkbook() module.

Answer 2

Auto_Open is the name defined for an XLM macro. For VBA, use the workbook_open event in the thisworkbook code page.

Answer 3

I don't get an error message.  It just seems that the macro doesn't run.  In my efforts to figure out what the problem is, I created a new workbook with a simple macro:

Sub Auto_Open()

MsgBox "It works."

End Sub

When I open the workbook, I don't see the message box.  If I run the macro "manually", I see the message box.

I'm stumped.

Answer 4

Auto_Open() works fine in Excel for Mac.

Are you getting an error message? What happens when you try to run your macro?

Answer 5

Macros should be written I believe it's called Classic. Active-X doesn't exist on Mac.

One of the MVP's will most likely give the correct Macro Language.