Macro to select a view

K

Kent McPherson

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

Kent McPherson

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

Kent McPherson

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

regards

FSt1

:
Click to expand...

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?
 

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

Similar Threads

View what macro is assigned to a tool bar button 1
vba powerpoint pasting named shape in selected named slides 0
Macros I want dont appear in the customise box to drag to a toolbar 1
How to call Excel add-in macro from a button… 1
Select rows with visible data 0
Custom Macro 2
Unable to assign macros to a new button in the current worksheet 1
migrate xls app 2003 to 2007 -- get custom macro button out of des 3

Top