Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro, or excel program to "Close All' while in a workspace
Put this macro in your Personal.xls workbook as a module...
'/=====================================/ Sub CloseEmAll() Dim wb As Workbook For Each wb In Workbooks If UCase(wb.Name) < "PERSONAL.XLS" Then ' Application.DisplayAlerts = False wb.Close ' Application.DisplayAlerts = True End If Next wb End Sub '/=====================================/ This will close all open workbooks, hidden or visible with the exception of the Personal.xls. It will not save the opened workbooks. To have Excel ask you if you want to save any changed workbooks, uncomment the 'DisplayAlerts' lines. HTH, -- Gary Brown "Carlton Patterson" wrote: 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 *** |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro, or excel program to "Close All' while in a workspace
Hi Gary,
Thanks for responding to my request. That is exactly what I needed. Cheers mate. Carlton *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding a Close Workspace option when right-clicking Excel in taskb | Setting up and Configuration of Excel | |||
Excel program close suddenly | Excel Discussion (Misc queries) | |||
Is there a way to unload the loaded XLL file in Excel? Hi all, I amdebugging XLL link library using Visual C++. Everytime I rebuild the XLL, Ihave to close the whole Excel program and relaunch the Excel program again,and then load in the newly gene | Excel Discussion (Misc queries) | |||
Excel 2003 not responding to "X" to close program | Excel Discussion (Misc queries) | |||
Macro, or excel program to "Close All' while in a workspace | Excel Programming |