Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Groups and Protection
Hi All
I have code that generates a sheet with various groupings on it. However since I want this sheet protected you are not able to use the grouping buttons. Short and Curlies : Is it possible to use groups on a protected sheet? Thanks heaps Jay |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Groups and Protection
Jay wrote:
Is it possible to use groups on a protected sheet? A worksheet has an EnableOutlining property Make it true and you can use the grouping buttons. The property is not saved with the workbook so you need to set it up on opening the workbook and, bizarrely, set userinterfaceonly protection: Sub Auto_Open() With ThisWorkbook.Sheets("SHeet1") .Protect UserInterfaceOnly:=True .EnableOutlining = True End With End Sub Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - reply in newsgroup |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Data Protection Best Practice: AKA: Real Sheet Protection | Excel Discussion (Misc queries) | |||
Excel Data Protection- AKA: Sheet/Macro Password Protection | Setting up and Configuration of Excel | |||
Excel - Sorting groups in groups due to subtotaling | Excel Worksheet Functions | |||
WS Protection: Different Levels of Protection on Different Ranges | Excel Discussion (Misc queries) | |||
how do i view all groups under excel in google groups | Excel Discussion (Misc queries) |