Sort on close - Possible?

[Guest]

I would like to select cells $A$13:$H$500 and sort by column A with text
sorting as numbers on workbook close or save.

Can anyone help?

Cheers

 

[Guest]

I'm not sure of it, have heard of it tho.

But if you were to create a macro that sorted out your data for you.

There is, I'm sure of a way of running a macro on exit.

(I think running a macro on exit is normally for validation purposes, but
it's all the same)

You should search and repost if needed for "running a macro on exit" or
something similar.


hope you can find what you're looking for. I've discovered a need for this
in the past, so will look around to see if I can find anything. If I do, I'll
let you know

Dan

 

[Dave Peterson]

There's a workbook_beforesave event that you may want to try.

But if you use the workbook_beforeclose event, the user may not save--and if you
save for him/her, it might not be what they want.

If you really want the data sorted for the next time the user opens the
workbook, you could sort it in the workbook_open event (or auto_open sub).