I have an Excel 2002 spreadsheet that does some automatic calculations when the user clicks on the command button. I would like the spreadsheet to run a particular macro when it first loads.
I've tried putting code in Worksheet_Activate, but of course that doesn't run until the user selects the sheet. I don't want the user to have to do anything, I just want it to run automatically.
Any suggestions? Thanks in advance.
