Hi...what do I name a macro to get it to run when I open a workbook.

Thanks in advance.

Pete

Hi Pete

Sub Auto_open()

HTH. Best wishes Harald


"Pete Jones" skrev i melding
...
Hi...what do I name a macro to get it to run when I open a workbook.

Thanks in advance.

Pete

Private Sub workbook_Open()

end Sub

and place it in the ThisWorkbook.Module

or use the older


Sub Auto_Open()

end Sub

and place it in a general module.

--
Regards,
Tom Ogilvy

"Pete Jones" wrote in message
...
Hi...what do I name a macro to get it to run when I open a workbook.

Thanks in advance.

Pete