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

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