Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I've created a worksheet for others to use with grouped and outlined sections
so the user can view the information either expanded with detail or collapsed to hide the detail. This worksheet also contains certain cells that are protected from the user making changes to them. When the protection is activated and I try to use the hide or show detail option I get this error message. "You cannot use this command on a protected sheet" Is there a way to protect certain cells and allow the user to show and hide detail depending upon their preference. I'm using Excel 2003, MS Windows XP Pro. Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Retrieve data from all of the worksheet within the file | Excel Worksheet Functions | |||
Saving data in a worksheet within a workbook | Excel Discussion (Misc queries) | |||
Weekly Transaction Processing | Excel Worksheet Functions | |||
how to hide rows in a protected sheet | Excel Worksheet Functions | |||
Why can't I show or hide rows in an outline on a protected sheet? | Excel Discussion (Misc queries) |