View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
StargateFan[_3_] StargateFan[_3_] is offline
external usenet poster
 
Posts: 171
Default CLOSE ALL macro for XL2K (but with prompt to save for each file)?

Word's CLOSE ALL isn't as nice as WP's - where a small box appears and
you just tick to save or not in a box under each column whether or not
to save for each open file - but it still is good in that it prompts
you before closing each file. I searched yesterday for VB code for
Excel and it seems that there are only 2 kinds: either you save all
files or save none, arbitrarily, while closing all. This isn't good.
Is there code anywhere that prompts for each open file whether or not
to save each one before closing all open workbooks? Tx.