Autorun

  • Thread starter Thread starter jee22
  • Start date Start date
J

jee22

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

Thanks

Sap

--
 
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 **
 
Thank you, I tried that and it did not work
Paul B said:
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 **
Click to expand...
 
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 **
 
Back
Top