+ Reply to Thread
Results 1 to 2 of 2

Using Excel Group / Ungroup with Protected Worksheet/Workbook

  1. #1
    Registered User
    Join Date
    03-01-2013
    Location
    Seattle, WA
    MS-Off Ver
    Excel 2010
    Posts
    16

    Using Excel Group / Ungroup with Protected Worksheet/Workbook

    I'm having dificulty getting the following Sub to run within my Excel 2010 *.xlsm file. I have the following pasted at top of my VB editor window. My worksheet, "STA High Power ASSY" is already setup with Excel grouping feature. However, when I protect the worksheet, the grouping and ungrouping does not work. I entered the following in my VB editor. Macros are enabled. It may not be an issue with Sub, but may be my workbook, not sure.

    Private Sub Workbook_Open()
    With Sheets("STA High Power ASSY")
    .Unprotect Password:="Secret - Password entered here"
    .Protect Password:="Secret - Password", UserInterfaceOnly:=True
    .EnableOutlining = True
    End With
    End Sub

    Thank you,
    Lynn

  2. #2
    Registered User
    Join Date
    06-25-2013
    Location
    Barbados
    MS-Off Ver
    Excel 2010
    Posts
    1

    Re: Using Excel Group / Ungroup with Protected Worksheet/Workbook

    I have the same issue, I am using Excel 2010. Macros enabled, but the grouping/ungrouping functionality does not work when the worksheet is protected. Can someone please assist. The code typed in VBA is:

    Sub Password_Protection()

    With Worksheets("Sheet2")

    .EnableOutlining = True

    .Protect Password:="", Contents:=True, UserInterfaceOnly:=True

    End With

    End Sub

    Please help!!

+ Reply to Thread

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