Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do i enable "Group" & "Ungroup" in a protected sheet
THANK YOU! Its a great help
"Debra Dalgleish" wrote: If you protect the worksheet programmatically, you can enable outlining, and you will be able to use the groups that you have created. The following code goes in the ThisWorkbook module: Private Sub Workbook_Open() With Worksheets("Sheet1") .EnableOutlining = True .Protect Password:="password", _ Contents:=True, UserInterfaceOnly:=True End With End Sub To paste the code into the ThisWorkbook module: Right-click on the Excel icon, to the left of the File menu Choose View Code Paste the code where the cursor is flashing. Fadi Haddad wrote: 1 -I have grouped data in my excel sheet by using the Group rows function. 2- When i protect the sheet, the goup and Ungroup button (the + sign at the left of the sheet), won't work. Question: Is there a way to proctect the sheet and keep the Group and ungroup (+ sign)function normally. Thank you -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
Protected sheet spell check | Excel Discussion (Misc queries) | |||
Down arrow moves cursor to top of worksheet when sheet protected | Excel Worksheet Functions | |||
Lookup function and compare | Excel Discussion (Misc queries) | |||
Protected sheet to unprotected sheet | Excel Worksheet Functions |