Macros

curator · Mar 11th, 2002, 09:59 PM

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 · Mar 11th, 2002, 10:00 PM

Sure, put it in the Workbook_Open event.

NateO · Mar 11th, 2002, 10:01 PM

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 · Mar 11th, 2002, 10:36 PM

Where do I find the Workbook_Open event???

Russell Hauf · Mar 11th, 2002, 10:38 PM

Quote:

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.p...1960&forum=2&4

Mar 11th, 2002, 10:00 PM	#2
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,758	Sure, put it in the Workbook_Open event. __________________ Regards, Juan Pablo González http://www.juanpg.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 11th, 2002, 09:59 PM	#1
curator Join Date: Mar 2002 Posts: 29	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

Mar 11th, 2002, 10:01 PM	#3
NateO MrExcel MVP Admin Join Date: Feb 2002 Location: Minneapolis, Mn, USA Posts: 9,639	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 ]

Mar 11th, 2002, 10:36 PM	#4
curator Join Date: Mar 2002 Posts: 29	Where do I find the Workbook_Open event???