Thread: Auto Run Macro
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dorci Dorci is offline
external usenet poster
 
Posts: 29
Default Auto Run Macro

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.