Running Macros Automatically

[corkenstien]

Is there a way to have a macro run automatically when the workbook is opened. I know I can go to the macro and click run macro or I can create a hot key that will run the macro but what I really want is for it to run itself as soon as the workbook is opened. Any help would be greatly appreciated. Thanks in advance.

[vbace2]

You can put the macro in the workbook_open event. Instead of creating the macro in a module, you can put the code here. Or, you can still put the code in a module and then just call it from here.


Private Sub Workbook_Open()

End Sub

[corkenstien]

Where would I put the code

Private Sub Workbook_Open()

End Sub

I'm new to macros, and not sure what you are telling me. Sorry

[vbace2]

Go into the edit (ALT-F11).

Open up the Microsoft Excel Objects and double-click on ThisWorkbook. This is probably empty. You can put the

Private Sub Workbook_Open()

End Sub

in there. You can then either put your macro code in there, or you can put...

Call MACRONAME

in there. I think this should work for you.

[corkenstien]

You are the MAN.