Autorun

[jee22]

Can anyone tell me how to auto run a macro as soon as you open
a sheet/workbook (excel 2000, win2000)

Thanks

Sap

--

 

[Paul B]

Put this in thethis workbook code

Private Sub Workbook_Open()
'your code here
End Sub


--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **

 

[jee22]

Thank you, I tried that and it did not work

Put this in thethis workbook code

Private Sub Workbook_Open()
'your code here
End Sub


--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **

 

[Paul B]

You may have to change the macro security settings to get the macro to run.
Tools, macros, security

--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **

 

[jee22]

Thanks Paul ... I got there in the end .... very grateful