Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: autostart macro???

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  2. #2
    MrExcel MVP Al Chara's Avatar
    Join Date
    Feb 2002
    Location
    Newark, Delaware
    Posts
    1,701
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.
    Best regards,
    Allan Chara
    http://www.mrspreadsheets.com

  3. #3
    Board Regular
    Join Date
    Apr 2002
    Location
    Minnesota
    Posts
    821
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •