Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Grouping in protected sheets
Hi,
I have a sheet where I need to protect some formulas so that people won't mess them. However, when I do this Excel does not let me use the + (or -) buttons to open the groupings. Any suggestions how to handle this problem? thanks in advance!! Maya |
#2
|
|||
|
|||
You have to set the worksheet's EnableOutlining property to true.
Unfortunately this is a setting that must be set every time you open the workbook because it does not stick. You can run this code in your workbook's startup macro to handle this. With Worksheets("Sheet1") .EnableOutlining = True .Protect Password:="pass" End With -- Jim Rech Excel MVP "Maia" wrote in message ... | Hi, | | I have a sheet where I need to protect some formulas so that people won't | mess them. However, when I do this Excel does not let me use the + (or -) | buttons to open the groupings. | Any suggestions how to handle this problem? | | thanks in advance!! | | Maya | | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple sheets selected | Excel Discussion (Misc queries) | |||
Printing separate sheets on one paper sheet | Excel Discussion (Misc queries) | |||
Linking sheets to a summary sheet in workbook | Excel Discussion (Misc queries) | |||
linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) | |||
Protected cells -automatically format to a different color | Excel Discussion (Misc queries) |