+ Reply to Thread
Results 1 to 2 of 2

Advanced Filter on Protected Sheets?

  1. #1
    documike
    Guest

    Advanced Filter on Protected Sheets?

    Thanks to everyone who responded with some great ideas. Another user
    verified that when using the Copy function of Advanced Filter, when it
    copies and theres already data in cells anywhere below the targeted area, it
    wipes them clean.

    What I ended up doing was Advanced Filter / Copy to another location on the
    same sheet out of the view area...then referenced those cells on Sheet 2
    instead of doing a copy to Sheet 2. Problem solved.

    Now my only issue is when I protect the sheet, and try to run the macro
    that runs the Advanced Filter it says it can't run on a protected sheet. Is
    there any way around this? I want to protect the sheet because it's
    basically a form that end users will use over and over and if data in any of
    the formula cells gets changed, it will mess up the rest of application.
    Thanks again.



  2. #2
    Debra Dalgleish
    Guest

    Re: Advanced Filter on Protected Sheets?

    In the macro, unprotect the sheet, run the filter, then reprotect the sheet.

    documike wrote:
    > Thanks to everyone who responded with some great ideas. Another user
    > verified that when using the Copy function of Advanced Filter, when it
    > copies and theres already data in cells anywhere below the targeted area, it
    > wipes them clean.
    >
    > What I ended up doing was Advanced Filter / Copy to another location on the
    > same sheet out of the view area...then referenced those cells on Sheet 2
    > instead of doing a copy to Sheet 2. Problem solved.
    >
    > Now my only issue is when I protect the sheet, and try to run the macro
    > that runs the Advanced Filter it says it can't run on a protected sheet. Is
    > there any way around this? I want to protect the sheet because it's
    > basically a form that end users will use over and over and if data in any of
    > the formula cells gets changed, it will mess up the rest of application.
    > Thanks again.



    --
    Debra Dalgleish
    Excel FAQ, Tips & Book List
    http://www.contextures.com/tiptech.html


+ 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