 |
|
|
|
|
|
Enable Grouping & Outline/Outlining on a Protected Worksheet. See Also: Excel Auto Outline and Excel Manual Outline
In Excel 2000 Microsoft added
many new levels of Worksheet protection to Excel. Unfortunately they have
neglected to add one that would allow Excel users to use
Grouping/Outlining
on a protected
Worksheet.
The code below can be used to allow the use of Grouping/Outlining on a protect
Worksheet. It makes use of
Excels
UserInterfaceOnly Argument of the Protection Method
which it normally
used to keep the general Excel interface protected, but allow changes from
Excel macros. The closing of the Workbook however will set the UserInterfaceOnly back to False. This is why we need to use the Workbook
Open event to set it to True.
To use the macro code below, right click on the Excel icon, top left next to
"File" and choose "View Code" in here paste the code
below. Then save the Workbook, close it, and reopen it, ensuring you enable
macros. I have used the
Worksheet
CodeName
to reference the correct Worksheet, but you can use the tab
name, or sheet index number. The use of the
Worksheets CodeName
is the best way.
Private Sub Workbook_Open()
With Sheet1
.Protect Password:="Secret", UserInterfaceOnly:=True
.EnableOutlining = True
End With
End Sub
Excel Dashboard Reports & Excel Dashboard Charts 50% Off Become an ExcelUser Affiliate & Earn Money
Special! Free Choice of Complete Excel Training Course OR Excel Add-ins Collection on all purchases totaling over $64.00. ALL purchases totaling over $150.00 gets you BOTH! Purchases MUST be made via this site. Send payment proof to special@ozgrid.com 31 days after purchase date.
Instant Download and Money Back Guarantee on Most Software
Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!
Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft
GIVE YOURSELF OR YOUR COMPANY 24/7 MICROSOFT EXCEL SUPPORT & QUESTIONS