Results 1 to 7 of 7
  1. #1
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Atlanta
    Posts
    568
    Thanks
    7
    Thanked 1 Time in 1 Post

    Searching Password Protected Worksheets (XP)

    I am a college professor and I keep my grades in password protected Excel worksheets. When a student comes to me and wants a letter of recommendation, I would like to search these worksheets automatically and pull up all their grades from each class they took from me but the Windows search function seems to skip password protected files. Is there some way to do this fairly easily.

    Ronny
    Ronny Richardson

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Searching Password Protected Worksheets (XP)

    I am confused. Password protected worksheets can be searched.

    Is the issue that you also have that you can only select unlocked cells? If you can only select unlocked cells it won't be able to find(and select) anything except the unlocked cells.

    Steve

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Searching Password Protected Worksheets (XP)

    I think he is using the Windows Search to look for text in a file, not the Excel Search once the file is open.
    Legare Coleman

  4. #4
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Atlanta
    Posts
    568
    Thanks
    7
    Thanked 1 Time in 1 Post

    Re: Searching Password Protected Worksheets (XP)

    That is correct. I have one worksheet per semester and I have been teaching a long time. What I do now is open them manually one-at-a-time and look for the names. What I would like to do is have Windows Search just present me with a list of those that contain the name so I could just quickly open the ones I need. However, it ignores password protected files. (It actually makes sense that it would do that, I was just hoping there was an approach that would work.)

    Ronny
    Ronny Richardson

  5. #5
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Searching Password Protected Worksheets (XP)

    It might be easier to create a master index with the names of all the students and hyperlinks to the appropriate files.

    Then you can open up this file, search/filter as appropriate and click to open the file(s).

    Steve

  6. #6
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Searching Password Protected Worksheets (XP)

    Sorry, I do not know of an easy way to accomplish this. You could write VBA code that would open each workbook and search it, but the code would have to know the password for all of the workbooks to be able to open them.
    Legare Coleman

  7. #7
    3 Star Lounger
    Join Date
    Jul 2001
    Location
    San Jose, California, USA
    Posts
    290
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Searching Password Protected Worksheets (XP)

    Are you using a separate workbook each semester or a separate worksheet in a single workbook? It sounds like the former, but you used the word woksheet in your post. Have you tried importing each file into separate worksheets in a single workbook. You could password protect that one file and then use the Excel search function to search every sheet in the workbook. At the start of each academic year you could import however many semesters you need to track into a new workbook and add new sheets for the upcoming semesters.

Posting Permissions

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