FSt1 wrote:
hi
ActiveWorkbook.CustomViews("myview").Show

regards

FSt1

"Kent McPherson" wrote:


Is there a VBA macro statement that will select a custom view? I'd like
to assign such a macro to a button.


How about hiding particular worksheets by clicking on buttons to hide
them? In other words, I have worksheets A, B, C, D, & E. I want to have
buttons that say "Hide A", "Hide B", etc. Or maybe set up a checklist
that shows which sheets to hide or show. I want the user of the
spreadsheet to be able to customize what he/she actually sees. Thoughts?