Thread: How to create a button to switch to a custom view
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bearacade[_14_] Bearacade[_14_] is offline
external usenet poster
  
Posts: 1
Default How to create a button to switch to a custom view

create a button, double click on the button while you are still in
design mode and enter this in the sub:

ActiveWorkbook.CustomViews("???").Show

put in the name of your Custom View in ???

I would save a version as "normal" and make a button for that too.


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=552415

Reply With QuoteReply With Quote