Auto starting an Excel macro - Help!
Posted by adrian N on December 17, 2001 5:40 PM
I can't auto run my macro when the sheet is loaded.
I have tried...
'This lives in Module1
Private Sub workbook_open()
'This lives in This WorkBook
Both these methods generate the same "Compile Error"...
"Sub or Function not defined"
My spreadsheet only has one Sheet called "Roster", which is where my macro code resides.
To get it working, I have placed a button on the sheet to manually get the macro running.