View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Spreadsheet Solutions Spreadsheet Solutions is offline
external usenet poster
 
Posts: 33
Default Sort several workbooks using code

I'm not aware of sorting records in a CLOSED workbook, but what you can do
is this.

Create some button on the master workbook and let it open the other
workbook, sort the other workbook and close the other workbook.
Accompanied with Application.ScreenUpdating (but also depending on the
amount of records) you will hardly notice the sorting actions.

Does this help ?


--
Regards;
Mark Rosenkrantz
--
Spreadsheet Solutions
Uithoorn
Netherlands
--
E:
W:
www.spreadsheetsolutions.nl

--
"gotroots" wrote in message
...
I am looking to run code that will sort several workbooks even when they
are
closed. The code would be executed via a master workbook which will also
be
sorted.
Is this possible?