Thread: Limit of # of different custom views & Automate printing diff view
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
wjohnson
 
Posts: n/a
Default Limit of # of different custom views & Automate printing diff view

I think you have to make the Views you want for each sheet. I just tried
it on an example (created a Custom View on Sheet1) when I was on Sheet2
- and run the View - It goes back to Sheet1.
For the button part of selecting the views - You might try doing a
macro - then make a CUSTOM TOOLBAR and adding the macro to the toolbar.


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640
View this thread: http://www.excelforum.com/showthread...hreadid=496677

Reply With QuoteReply With Quote