View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Carlton Patterson Carlton Patterson is offline
external usenet poster
 
Posts: 95
Default Macro, or excel program to "Close All' while in a workspace

Hello all,

I usually run a couple of workbooks in one workspace and the only way to
close the workbooks within a workspace is to either:

1) Close each workbook individually

2) Holding the 'shift' key and clicking on 'file' and then clicking on
'close all'.

I have been trying to record a macro to make this easier, but without
any success.

Can someone either let me know if there is another way to close a number
of workbooks within a workspace or help me put together a macro or an
excel program that will alleviate this laborious action?

Cheers

Carlton

*** Sent via Developersdex http://www.developersdex.com ***