Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Is is possible to collapse and uncollapse outlines data when a worksheet is
protected by clicking on the "+" "-" buttons or the "1" "2" etc buttons. I have a workbook on which one of the sheets in interactive for people to complete, however I need to protect some of the cells and then protect the worksheet so that formulas and some data cannot be amended. To make the worksheet interface userfriendly, I have outlined some columns and rows. However, when I protect the worksheet it does not allow me to use this functionality. Please can someone help and advise if this function is still possible when protecting a worksheet, and if so, how? many thanks Afsha |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Manual control of link updating for downloaded quotes? | Excel Discussion (Misc queries) | |||
sorting data on protected worksheet | Excel Discussion (Misc queries) | |||
Excel 2003, Convert EXISTING Worksheet Data to XML? | Excel Discussion (Misc queries) | |||
Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) | |||
Sort pages? | Excel Discussion (Misc queries) |