View Full Version : [SOLVED:] Enable use of "Grouping" with Excel 2000
malik641
09-04-2005, 12:52 PM
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????
malik641
09-05-2005, 06:32 PM
I also noticed that this is the same for 2003.
Can anyone help me!?!?!
austenr
09-05-2005, 07:19 PM
Try unlocking the cells before you protect the sheet.
malik641
09-05-2005, 07:35 PM
No good....:mkay
malik641
09-06-2005, 04:47 AM
Got it. Thanks to Dave Peterson, the code is:
Option Explicit
Private Sub Workbook_Open()
With Worksheets("sheet1")
.Protect Password:="hi", userinterfaceonly:=True
.EnableOutlining = True
End With
End Sub
Awesome :thumb
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.