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.
|