How to execute a macro when document open

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sciamano - 12 Oct 2006 23:51 GMT

Hi. I've registered a macro, how can I execute it every time that I open the
document??

Thanks

Reply to this Message

Bob Phillips - 13 Oct 2006 00:35 GMT

Private Sub Workbook_Open()
Call myMacro
End Sub

'This is workbook event code.
'To input this code, right click on the Excel icon on the worksheet
'(or next to the File menu if you maximise your workbooks),
'select View Code from the menu, and paste the code

Signature

HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

> Hi. I've registered a macro, how can I execute it every time that I open the
> document??
>
> Thanks

Reply to this Message