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

Dave Peterson

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.

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