| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide rows and prevent unhiding
Add a 2nd worksheet ("Views") right after the worksheet with the data
("Data"). Put the view settings on the "View" worksheet, then hide it (and protect it, if you think you need to). The only problem might be if the user tries to delete rows or columns on the "Data" worksheet (maybe have a change event macro to catch this?). -- Regards, Bill Renaud |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unhiding Rows | Excel Discussion (Misc queries) | |||
| Prevent unhiding columns | Excel Discussion (Misc queries) | |||
| Unhiding rows | Excel Discussion (Misc queries) | |||
| How do I prevent hidden rows from unhiding when resizing row ht? | Excel Discussion (Misc queries) | |||
| How to Prevent User from Unhiding Sheet | Excel Programming | |||
Threaded Mode
