Results 1 to 2 of 2
  1. #1
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Yilgarn region of Toronto, Ontario
    Posts
    5,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    SaveAll (Excel 97+)

    I've just noticed (after all these years) that Excel does not appear to boast a "SaveAll" command when the Shift-File menu is used.
    At least, not in my copies of Excel97, 2000, 2002, 2003.

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

    Re: SaveAll (Excel 97+)

    You're correct. The Close menu option changes to 'Close All' when Shift is held down, but Save isn't affected.

    See MSKB article XL2000: How to Programmatically Save All Open Workbooks for a custom replacement.

Posting Permissions

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