Results 1 to 5 of 5
  1. #1
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: worksheet macros (w98)

    I do not understand your question.

    Could you elaborate? What macros, what does "on the model" mean?

    Macros can be stored in a variety of places.

    Steve

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: worksheet macros (w98)

    If the file you are opening has macros, then those macros will be there when the file is opened. If you have the same macros in your Personal.xls, then you are going to have two copies of the macros. The only way to correct this is to delete the macros from whichever file you don't want them in and save that file.
    Legare Coleman

  3. #3
    3 Star Lounger
    Join Date
    May 2002
    Location
    Mpls, Minnesota, USA
    Posts
    271
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: worksheet macros (w98)

    Or maybe just rename the macros that have the same name.

    chuck
    Chuck Reimer
    I'm from the Government and I'm here to help...

  4. #4
    New Lounger
    Join Date
    Mar 2002
    Location
    cincinnati oh
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    worksheet macros (w98)

    not sure how to update but here goes - was apparently not clear in original. An example would be newfile.xls, starting from scratch using the personal.xls template. after building and saving as newfile.xls, sometimes when I re-open the file it shows only the personal.xls macros. If I build another file, dif_file.xls, in the same way, when I re-open it, it will have copied the macros and made them part of dif_file.xls, so I have redundant macros. I'm looking for a way to avoid the redundant saving in the first place, and for a quick and dirty way to delete the dif_file macros without having to step thru them one at a time.

    I keep getting files loading with the macros stored on the model as well as personal.xls, whereas others load without that condition. Why is that? and is there a way to easily get rid of the redundant macros? thanx

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: worksheet macros (w98)

    Personal.xls is not meant to be used as a template, it is a container for macros you want to be available whenever you use Excel. So you should not create new workbooks based on Personal.xls.

Posting Permissions

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