Macro to select a view
 

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

Macro to select a view
 

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.

Macro to select a view
 

ActiveWorkbook.CustomViews(-nameOfCustomView-).Sho

--
TommySzalapsk
-----------------------------------------------------------------------
TommySzalapski's Profile: http://www.excelforum.com/member.php...fo&userid=2556
View this thread: http://www.excelforum.com/showthread.php?threadid=39090

Macro to select a view
 

Thank you!! Exactly what I needed.

*** Sent via Developersdex http://www.developersdex.com ***

Macro to select a view
 

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?


*** Sent via Developersdex http://www.developersdex.com ***

Macro to select a view
 

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?

Macro to select a view
 

Worksheets(-nameOfSheet- ).Visible = Fals

--
TommySzalapsk
-----------------------------------------------------------------------
TommySzalapski's Profile: http://www.excelforum.com/member.php...fo&userid=2556
View this thread: http://www.excelforum.com/showthread.php?threadid=39090