Sure, put it in the Workbook_Open event.
Hey all, is there a way to make it so when you open an excel spreadsheet, the first thing it does is run a macro?
Thanks
-Lewis
lewis@lewisystems.net
Try this:
sub auto_open
application.run("Your Macro Name")
end sub
Don't include the "sub".
FYI, workbook_open goes into the "ThisWorkbook" module. The code above goes into any old normal module.
Hope this helps. Cheers,
Nate
[ This Message was edited by: NateO on 2002-03-11 17:02 ]
Where do I find the Workbook_Open event???
See the last post on this link (by Anonymous):On 2002-03-11 17:36, curator wrote:
Where do I find the Workbook_Open event???
http://mrexcel.com/board/viewtopic.p...1960&forum=2&4
Like this thread? Share it with others