+ Reply to Thread
Results 1 to 2 of 2

outline macro not allowing filtering on a protected sheet

  1. #1
    Registered User
    Join Date
    01-10-2014
    Location
    Taylors, SC
    MS-Off Ver
    Excel 2007
    Posts
    3

    outline macro not allowing filtering on a protected sheet

    I have the following macro so that we can use the outline feature without having to unprotect a sheet.

    Private Sub Workbook_Open()
    With Worksheets("Schedule")
    .Protect Password:="APQP", Userinterfaceonly:=True
    .EnableOutlining = True
    End With
    With Worksheets("Feasibility")
    .Protect Password:="APQP", Userinterfaceonly:=True
    .EnableOutlining = True
    End With
    .
    .
    .
    With Worksheets("Launch")
    .Protect Password:="APQP", Userinterfaceonly:=True
    .EnableOutlining = True
    End With
    End Sub


    However once the macro is run, filtering will not work without unprotecting the sheet first. If you choose not to run the macro, filtering will work without unprotecting the sheet however the outline feature will not.

    Can somebody tell me what I need to add and where to make both the outline and filter features to work without having to unptotect the sheet?

    NOTE: I am in no way VBA versed; the above code was found and modified on the web
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    01-10-2014
    Location
    Taylors, SC
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: outline macro not allowing filtering on a protected sheet

    Never mind, found it.

    I added:
    .EnableAutoFilter = True
    to the next line after each "enableoutlining" statement
    thought I had tried that and got an error, must have had a typo or something.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How can I allow an outline to be collapsed on a protected sheet?
    By LynnAnnO in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM
  2. How can I allow an outline to be collapsed on a protected sheet?
    By LynnAnnO in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM
  3. How can I allow an outline to be collapsed on a protected sheet?
    By LynnAnnO in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  4. How can I allow an outline to be collapsed on a protected sheet?
    By LynnAnnO in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 PM
  5. Cannot Outline Rows in protected sheet
    By helmekki in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-20-2005, 08:50 AM

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