Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sort on close - Possible?
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sort on close - Possible?
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 --- iPod's ROCK! "Adamski" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sort on close - Possible?
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). Adamski wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
why do all excel worksheets/workbooks close when I close one? | Excel Discussion (Misc queries) | |||
close button does not close | Excel Discussion (Misc queries) | |||
Pls. reply Sort Data and copy to next coulmn when sort order chang | Excel Programming | |||
Excel shoud not close all active books when clicking close button | Excel Discussion (Misc queries) | |||
excel - Windows close button (x) should only close active workboo. | Setting up and Configuration of Excel |