Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Custom Views | Setting up and Configuration of Excel | |||
Can I protect/lock columns AND set custom views? | Excel Discussion (Misc queries) | |||
Hiding columns, custom views, protected sheet | Excel Discussion (Misc queries) | |||
How to password protect hidden columns and custom views in Excel | Excel Discussion (Misc queries) | |||
Hiding columns and custom views problem | Excel Discussion (Misc queries) |