Excel 2003 - I have this macro, but it doesn't run when I open the workbook:

Private Sub Workbook_Open()
Application.CommandBars("Cool Macros").Visible = True
End Sub

I can run the macro manually AFTER opening the workbook, but I want it to
run automatically. My ultimate goal is to install the "Cool Macros" toolbar
for ANYONE who opens this workbook. Any idea what I'm doing wrong.

Thanks in advance.

Never mind; I figured it out. It should be Auto_Open() instead.

"Dorci" wrote:

Excel 2003 - I have this macro, but it doesn't run when I open the workbook:

Private Sub Workbook_Open()
Application.CommandBars("Cool Macros").Visible = True
End Sub

I can run the macro manually AFTER opening the workbook, but I want it to
run automatically. My ultimate goal is to install the "Cool Macros" toolbar
for ANYONE who opens this workbook. Any idea what I'm doing wrong.

Thanks in advance.

It will work as either Workbook_Open or Auto_Open

Depends upon where you store the code.

Workbook_Open goes into Thisworkbook module.

Auto_Open goes into a general module.


Gord Dibben MS Excel MVP

On Thu, 5 Feb 2009 14:33:47 -0800, Dorci
wrote:

Never mind; I figured it out. It should be Auto_Open() instead.

"Dorci" wrote:

Excel 2003 - I have this macro, but it doesn't run when I open the workbook:

Private Sub Workbook_Open()
Application.CommandBars("Cool Macros").Visible = True
End Sub

I can run the macro manually AFTER opening the workbook, but I want it to
run automatically. My ultimate goal is to install the "Cool Macros" toolbar
for ANYONE who opens this workbook. Any idea what I'm doing wrong.

Thanks in advance.