Results 1 to 3 of 3

Enabling Grouping / Outline On A Protected Sheet VBA

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    09-23-2005
    Location
    Bristol, UK
    MS-Off Ver
    2007
    Posts
    664

    Enabling Grouping / Outline On A Protected Sheet VBA

    Hi all,

    I've been trying to work out how to allow a user to collapse and open groups on a protected sheet. Having Googled and checked this site out, I've found a few things. Up until now, I've been using the following code:

    Private Sub Workbook_Open()
        Dim ws As Worksheet
         
        For Each ws In Worksheets
             
            Select Case UCase(ws.Name)
            Case "RESOURCING"
                With ws
                    .Protect Password:="donottouch", UserInterfaceOnly:=True
                    .EnableOutlining = True
                End With
            Case Else
            End Select
             
        Next ws
         
    End Sub
    Now this works fine when you run it, however when the workbook is closed and reopened the ability to use the groups/outline function becomes locked as per a normally protected sheet.

    Can anyone suggest a modification that will keep the groups unlocked at all times on the protected sheet?

    TIA,

    SamuelT
    Last edited by SamuelT; 02-25-2009 at 08:21 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1