When a sheet is protected with grouped cells in Excel 2000, the user is unable to Expand and Collapse the Grouped cells. How can I enable that with a protected sheet on Excel 2000????
When a sheet is protected with grouped cells in Excel 2000, the user is unable to Expand and Collapse the Grouped cells. How can I enable that with a protected sheet on Excel 2000????
New to the forum? Check out our Introductions section to get to know some of the members here. Feel free to tell us a little about yourself as well.
I also noticed that this is the same for 2003.
Can anyone help me!?!?!
New to the forum? Check out our Introductions section to get to know some of the members here. Feel free to tell us a little about yourself as well.
Try unlocking the cells before you protect the sheet.
Peace of mind is found in some of the strangest places.
No good....
New to the forum? Check out our Introductions section to get to know some of the members here. Feel free to tell us a little about yourself as well.
Got it. Thanks to Dave Peterson, the code is:
AwesomeOption Explicit Private Sub Workbook_Open() With Worksheets("sheet1") .Protect Password:="hi", userinterfaceonly:=True .EnableOutlining = True End With End Sub
New to the forum? Check out our Introductions section to get to know some of the members here. Feel free to tell us a little about yourself as well.