Results 1 to 7 of 7
  1. #1
    2 Star Lounger
    Join Date
    Oct 2001
    Location
    Suffolk, England
    Posts
    134
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Filtering in Excel (Excel 2000)

    I havea spreadsheet with 3 proctected columns. It also has a filter on it - which obviously doesn't work when protection is on. The only way I can think of to get round this is to run a macro to take off the proctection when the cells with the filter buttons are clicked and put it back when any other cell is clicked.
    Is there a better way?
    If not, how do I run a macro when a cell is clicked
    Thanks
    Allison

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

    Re: Filtering in Excel (Excel 2000)

    You can allow AutoFilter in a protected sheet, see <post:=257,867>post 257,867</post:>.

  3. #3
    2 Star Lounger
    Join Date
    Oct 2001
    Location
    Suffolk, England
    Posts
    134
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Filtering in Excel (Excel 2000)

    Unless I'm doing something wrong, that doesn't seem to work - as far as I can tell, the macro isn't running

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

    Re: Filtering in Excel (Excel 2000)

    Can you attach a stripped down copy of the workbook? Replace sensitive content with dummy data.

  5. #5
    2 Star Lounger
    Join Date
    Oct 2001
    Location
    Suffolk, England
    Posts
    134
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Filtering in Excel (Excel 2000)

    thanks for looking at this - I attach the file
    Allison

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

    Re: Filtering in Excel (Excel 2000)

    Hi Allison,

    You have placed the Workbook_Open code in the module of the worksheet LOS 28. It should be in ThisWorkbook instead. It'll run automatically when you open the workbook.

  7. #7
    2 Star Lounger
    Join Date
    Oct 2001
    Location
    Suffolk, England
    Posts
    134
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Filtering in Excel (Excel 2000)

    Thanks - that's done it, it's easy when you know how!
    Allison

Posting Permissions

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