Startup Macro?

[grep]

How do I set up a macro to start up when the spreadsheet opens? Can this
be done in a template?

Thanks,

David

 

[Gord Dibben]

grep

Workbook_open() or Auto_open() sub.

Private Sub Workbook_Open()
'do your stuff or call a macro
End Sub

Workbook_Open() sub would be placed into the ThisWorkbook module.

Autpen() sub would be placed into a General module.

Yes, it can be done in a Template.

Gord Dibben Excel MVP

 

[IJzerman]

Like this ...

Sub workbook_open()
MsgBox "Blabla"
End Sub