LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 15
Default Custom Views + hidden columns does seem to work

Hi there,

I was hoping you could help with some custom views. I've figured out how to
create custom views just fine and have created 6 of them. What I wanted to
do next was create an identifier on the spreadsheet that would tell the user
which view is currently being used (for both viewing and printing).

I tried adding 6 rows at the top of the spreadsheet with the name of each
view in one row. I would then hide 5 rows and keep row with the view I want
identified visable. Then I would save the view. This works fine if I am
only hidding and unhidding rows and columns.

However....

I am also using autofilter, to only display specific items within each
column and have noticed that once I use the filter, all of my hidden rows
identifing the view are ingored when the view is saved.

Any ideas on how I can use filters, and hide rows in the same view? Or any
ideas on how I can make the current view the user has selected, visable for
printing and viewing?
--
RyGuy
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Custom Views Mervyn Thomas[_2_] Setting up and Configuration of Excel 0 September 5th 08 04:42 PM
Can I protect/lock columns AND set custom views? Meltad Excel Discussion (Misc queries) 0 July 31st 06 04:03 PM
Hiding columns, custom views, protected sheet Ian Excel Discussion (Misc queries) 0 May 4th 06 09:59 AM
How to password protect hidden columns and custom views in Excel blade444 Excel Discussion (Misc queries) 2 July 29th 05 01:36 PM
Hiding columns and custom views problem Bettergains Excel Discussion (Misc queries) 2 April 12th 05 11:48 PM


All times are GMT +1. The time now is 03:06 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"