autostart macro???

VHFlores · Apr 18th, 2002, 12:53 PM

how do i make an autostart macro, so that every time excel opens, the macro runs before anything else happens?
My real problem is that i dont like the default formatting for the columns. i just want to make all columns text!
row 1 '006' (excel thinks its a 6...BAD)
row 2 '201' (excel thinks its a 201...good)
row 3 '0GZ' (excel thinks its 0GZ...good)

if i then format the column as text, i can never turn the 006 in row 1 into a 006
This may be because i'm reading a file. A CSV file. The csv file has "006" , yet i cant
get it to show 006.

if excel opened/set all columns (well, a reasonable number) to text.../then show the data on the spreadsheet...everything would be cool

Al Chara · Apr 18th, 2002, 01:09 PM

Do a search on this site for auto start macros. You can put the code in the Workbook_Open event of the specific workbook, or save it to your personal.xls in the Workbook_Open or some other event and have it triggered everytime another workbook is opened, or you can save it as an add-in so it is loaded everytime excel is opened. You have many options here.

klb · Apr 18th, 2002, 01:57 PM

Make all the changes you want in a blank workbook. Then save the file twice.

First as "sheet.xls" - this sheet will open every time you start Excel.

Save it a second time in your xlstart directory as a template named "Book.xlt". This will then open whenever you want to open a new worksheet.

Good luck.

Apr 18th, 2002, 01:09 PM	#2
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	Do a search on this site for auto start macros. You can put the code in the Workbook_Open event of the specific workbook, or save it to your personal.xls in the Workbook_Open or some other event and have it triggered everytime another workbook is opened, or you can save it as an add-in so it is loaded everytime excel is opened. You have many options here. __________________ Kind regards, Al Chara

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

Apr 18th, 2002, 12:53 PM	#1
VHFlores New Member Join Date: Apr 2002 Posts: 1	how do i make an autostart macro, so that every time excel opens, the macro runs before anything else happens? My real problem is that i dont like the default formatting for the columns. i just want to make all columns text! row 1 '006' (excel thinks its a 6...BAD) row 2 '201' (excel thinks its a 201...good) row 3 '0GZ' (excel thinks its 0GZ...good) if i then format the column as text, i can never turn the 006 in row 1 into a 006 This may be because i'm reading a file. A CSV file. The csv file has "006" , yet i cant get it to show 006. if excel opened/set all columns (well, a reasonable number) to text.../then show the data on the spreadsheet...everything would be cool

Apr 18th, 2002, 01:57 PM	#3
klb Board Regular Join Date: Apr 2002 Location: Minnesota Posts: 821	Make all the changes you want in a blank workbook. Then save the file twice. First as "sheet.xls" - this sheet will open every time you start Excel. Save it a second time in your xlstart directory as a template named "Book.xlt". This will then open whenever you want to open a new worksheet. Good luck.