View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Trevor Shuttleworth Trevor Shuttleworth is offline
external usenet poster
 
Posts: 1,089
Default Execute procedure on startup

Richard

call the macro Auto_Start (in a general module) or use the Worksheet_Open
event (in the WorksheetClass Module)

Private Sub Workbook_Open()
:
End Sub


Regards

Trevor


"Richard" wrote in message
...
I would like to automatically run a procedure from within Excel upon

start.
I know that if I put the .xls file into the the subdirectory XLStart that
Excel will pull up the spreadsheet automatically, but then how do I then
automatically execute a designated procedure? Thanks for any help.