Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to enable grouping in a protected sheet
I am using grouping and ungrouping of cells. I want to protect few cells in
the sheet. So when I protect the sheet, I no more can group or ungroup the cells. Do we have a solution for this |
#2
|
|||
|
|||
Hi
aFAIK there's no solution for this "Ankur" wrote: I am using grouping and ungrouping of cells. I want to protect few cells in the sheet. So when I protect the sheet, I no more can group or ungroup the cells. Do we have a solution for this |
#3
|
|||
|
|||
I had the same problem, heres the fix: 1. Click on Tools-Macro-Visual Basic Editor 2. Double Click on "This Workbook" 3. Insert the Following Code: Private Sub Workbook_Open() ActiveSheet.EnableOutlining = True ActiveSheet.Protect contents:=True, userInterfaceOnly:=True End Sub 4. Click Save. The Workbook_Open() routine automatically runs when the workbook is opened. The next time you open the workbook you should be able to use the grouping functions on your protected worksheet! -- joltinjoe02 ------------------------------------------------------------------------ joltinjoe02's Profile: http://www.excelforum.com/member.php...o&userid=15949 View this thread: http://www.excelforum.com/showthread...hreadid=273169 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
List, Data Validation, unlocked cell, protected sheet..... | New Users to Excel | |||
Fill down on a protected sheet | Excel Discussion (Misc queries) | |||
Grouping in protected sheets | Excel Discussion (Misc queries) | |||
password protected Sheet | Excel Discussion (Misc queries) | |||
Why can't I show or hide rows in an outline on a protected sheet? | Excel Discussion (Misc queries) |