Home |
Search |
Today's Posts |
#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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |