Sort several workbooks using code

G

gotroots

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?
 
S

Spreadsheet Solutions

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 ?
 
G

gotroots

Your suggestion is a help for sure, might be the solution for this task.

Thank you
Gotroots
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top