Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: How do I get only one worksheet to open?

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

    Default

    I began saving macros in various workbooks that I was creating. I thought I saved them all to the "Personal" workbook. Now when I open excel, all the workbooks in which I ever saved a macro open. This happens now even though I deleted all the macros. How to I make excel open only a new worksheet when I first open it, and none of these other workbooks? Thx for any help.

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Is there an entry in the "Alternate startup file location" field on the Tools | Options... | General tab?

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Location
    Ontario, Canada
    Posts
    337
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    are the files located in XLstart folder that will cause them to start up when Excel is started.


  4. #4
    New Member
    Join Date
    Feb 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    There do not seem to be any entries in the "the Alternate startup file location" field on the Tools | Options... | General tab. How do I find the "XLstart folder that will cause them to start up when Excel is started"? Thxs for your replies.

  5. #5
    Board Regular
    Join Date
    Feb 2002
    Location
    Ontario, Canada
    Posts
    337
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Just do file search on c: drive for XLstart.

    Also I think sometimes even though you remove the code from a module in a macro recorded in "THis Work book" you need to remove the module the code was in(even if it's empty)

  6. #6
    New Member
    Join Date
    Feb 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Ok thx very much. I'll try it.

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
  •