Macros

[curator]

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

 

[Juan Pablo González]

Sure, put it in the Workbook_Open event.

 

[NateO]

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

 

[curator]

Where do I find the Workbook_Open event???

 

[Russell Hauf]

On 2002-03-11 17:36, curator wrote:
Where do I find the Workbook_Open event???

See the last post on this link (by Anonymous):

http://mrexcel.com/board/viewtopic.php?topic=1960&forum=2&4