Results 1 to 2 of 2
  1. #1
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    use filter on a protected sheet (2000 sr 1)

    is possible to use the filter on a protected sheet?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: use filter on a protected sheet (2000 sr 1)

    Yes, run this line of VBA code:

    Activesheet.EnableAutoFilter = True

    or, if it is for a specific sheet named Totale (for example), use

    Sheets("Totale").EnableAutoFilter = True

Posting Permissions

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