Auto Run Macro

D

Dorci

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top