Macro question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I created a macro in excel 2003. I would like the macro to run automatically
every time I open that particular spreasheet. Thank you in advance.
 
On the left side of the screen where you built the macro, you should see a
project folder that lists all of the sheets (CTL-R if you don't see it)
double-click the ThisWorkbook icon, and then at the top there are 2 drop
downs, chose the one on the left and select workbook, it will automatically
open the open event for the workbook, paste your code there.
 
Right-click on Excel Icon left of "File" on menubar.

Select "View Code.

Select Workbook from left side dialog box to get these lines

Private Sub Workbook_Open()

End Sub

enter your macro name between like

Private Sub Workbook_Open()
macroname
End Sub

This assumes that you have macroname installed in a module in the workbook.


Gord Dibben MS Excel MVP
 
That worked John, Thanks for your help. As you can see, I am new to macros
so this community and knowlegable people like yourself make our daily tasks
easier and fun.
 
Thanks for your help gord works great.

Gord Dibben said:
Right-click on Excel Icon left of "File" on menubar.

Select "View Code.

Select Workbook from left side dialog box to get these lines

Private Sub Workbook_Open()

End Sub

enter your macro name between like

Private Sub Workbook_Open()
macroname
End Sub

This assumes that you have macroname installed in a module in the workbook.


Gord Dibben MS Excel MVP
Click to expand...
 
What if my macro is saved on my personal macro workbook instead of that
particular spreadsheet?
 
Either copy the code from the macro and paste directly between the lines or add
this line.

Private Sub Workbook_Open()
Application.Run ("Personal.xls!macroname")
End Sub


Gord
 
Thanks for all your help.

Gord Dibben said:
Either copy the code from the macro and paste directly between the lines or add
this line.

Private Sub Workbook_Open()
Application.Run ("Personal.xls!macroname")
End Sub


Gord
Click to expand...
 
Back
Top