Thread: Autorun a macro
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
[email protected] raymond.allan@bench.com is offline
external usenet poster
 
Posts: 24
Default Autorun a macro

in a module ...

Sub Auto_Open

your code here

End Sub

As soon as the workbook is open the code in the Auto_Open sub will run