Execute Macro when spreadsheet Opened (Excel VBA)

[artsandcraftshome]

I have a spreadsheet with a macro that I have created a custom button for, but would like to execute the macro when the spreadsheet is opened. Then I'd like to be able to re-execute it (if necessary) using the button. Is this possible?
thanks
John

 

[Zathras]

You can do that quite easily. Just keep track of which code page does what. From the VBA editor, put your macro in a code module:
[blue]

Option Explicit

Sub DoSomething()
  MsgBox "Doing something"
End Sub

[/color]
Then on the sheet code page have this which runs the macro when the button is clicked:
[blue]

Option Explicit

Private Sub CommandButton1_Click()
  DoSomething
End Sub

[/color]
and on the "ThisWorkbook" code page have this which runs the macro when the workbook is opened:
[blue]

Option Explicit

Private Sub Workbook_Open()
  DoSomething
End Sub

[/color]