| 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 | |||
Linear Mode
