automatic launching of macro at startup

[dan_m]

I would like to have a macro launched everytime I open my
workbook, is there a simple way of doing this? Similarily,
I would like a macro ran automatically everytime I
close the wookbook. Any help would be appreciated- thx.

 

[Norie]

Dan

Take a look at the Workbook's open event.

It can be accessed by right clicking the small XL icon next to File on the main toolbar and selecting View Code.

That should open up the VBA editor in the ThisWorkbook module.

If you select Workbook from the left dropdown you should see this code stub.

Private Sub Workbook_Open()
     MyMacro
End Sub

This is where any code to be executed when the workbook is opened should go.

There is a similar BeforeClose event.

Private Sub Workbook_BeforeClose(Cancel As Boolean)
    MyMacro
End Sub

 

[dan_m]

thx.

that's exactly what i was looking for

keep well
Danny

 

[buckeye2281]

follow up question

I have just changed to Excel 2007. When I try to open the file it gives me this: "Cannot find 'AutoOpen Stub Data'!$A$1, which has been assigned to run each time masterproposal.xlsm is opened."

I have gone into the VBA editor and under Workbook I have this:

Private Sub Workbook_Open()

End Sub

I do not see where I can delete what it is asking for....I have Macro's in the workbook, but no longer one I have run when the book opens.

Any help in eliminating this error would be very much appreciated!

 

[buckeye2281]

To clarify I do not even know what AutoOpen Stub Data is??

I tried to put some code in there and it works, then gives me the Cannot find error.

I see this page in the VBA editor, I changed it from hidden to view, then deleted it....the error just changes to "cannot find ref ref"

Any suggestestions?

Again any help is appreciated....

 

[0 Agios]

Has anyone worked on this, I am having the same exact problem.