+ Reply to Thread
Results 1 to 2 of 2

Unable to filter on protected documents

  1. #1
    Registered User
    Join Date
    07-18-2008
    Location
    Keele
    Posts
    1

    Unable to filter on protected documents

    Yes the answer is normally to tick the filter option before protecting! However, this issue is occuring for only two people who have the same laptop and version of Excel:

    excel 2000 (9.06926-SP-3)

    Any help would be gratefully received

  2. #2
    Valued Forum Contributor
    Join Date
    06-30-2005
    Location
    Verwood, Dorset, England
    MS-Off Ver
    Excel 2000
    Posts
    479
    Quote Originally Posted by TraceyPughe
    Yes the answer is normally to tick the filter option before protecting! However, this issue is occuring for only two people who have the same laptop and version of Excel:

    excel 2000 (9.06926-SP-3)

    Any help would be gratefully received
    Hi Tracey Pughe

    Right click the excel logo left of File, then select View code and paste the following code to the This Workbook module

    Please Login or Register  to view this content.
    Change sheet 1, sheet 2 to match the protected worksheets, change range ("A3") to match the cell where your filters start
    Last edited by Paul Sheppard; 07-18-2008 at 12:01 PM.
    Paul

+ 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