View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Execute procedure on startup

Richard

In ThisWorkbook module.......

Private Sub Workbook_Open()
'your code here
End Sub

In a General module.......

Sub Auto_Open()
'your code here
End Sub

Gord Dibben Excel MVP

On Mon, 1 Mar 2004 13:56:05 -0800, "Richard"
wrote:

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.