Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Worksheet - various appearances
Hi - have a single worksheet on which I can use Custom Views to show/hide
different columns etc as I need. However, can I save a Sort order with each View as well as each custom view will have its own sort order and appearance - it's going to be a pain if I have to change the custom view then do a sort every time - is there a way round it - or am I stuck with changing the custom view and maybe assigning a button on the ribbon for a macro to sort for each view??? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Worksheet - various appearances
I think you're going to have to supply a macro for the sort.
As for me, I'd put all the settings that the View uses into the each macro and drop the views completely. I'd rather update the macro(s) than have to update the macro(s) and views. mkflirting wrote: Hi - have a single worksheet on which I can use Custom Views to show/hide different columns etc as I need. However, can I save a Sort order with each View as well as each custom view will have its own sort order and appearance - it's going to be a pain if I have to change the custom view then do a sort every time - is there a way round it - or am I stuck with changing the custom view and maybe assigning a button on the ribbon for a macro to sort for each view??? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel number appearances | Excel Worksheet Functions | |||
Multiple name appearances | Excel Worksheet Functions | |||
automatically appending newly added data on worksheet to a master list worksheet | Links and Linking in Excel | |||
counting appearances of a short string within strings in a whole worksheet | Excel Discussion (Misc queries) | |||
Upload multiple text files into 1 excel worksheet + put the filename as the first column in the worksheet | Excel Worksheet Functions |