Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi Everyone
I have a spreadsheet which allows people to enter some figures in some cells. Those cells then add together to creat bew totals. I want to allow them to see all the individual lines or allow them to use the group +or - (the rows have already been grouped) to change the views. But, if I lock some cells in those rows, the Group + or - no longer works. Is there anyway around? I've tried "Allow Format rows" as a protection option but it didn't work. I've tried to select the whole worksheet, unlocked it, then locked smalls parts, that didn't work either. If there is a solution, I'd love to hear from you! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using a Check Box to Lock/Unlock Cells | Excel Discussion (Misc queries) | |||
group&ungroup | Charts and Charting in Excel | |||
Lock/Unlock cells | Excel Worksheet Functions | |||
Lock and unlock cells conditionally depending on input in another | Excel Worksheet Functions | |||
Lock and Unlock cells using VBA | Excel Discussion (Misc queries) |