Security for viewing Excel rows or sheets

  • Thread starter Thread starter stevier
  • Start date Start date
S

stevier

I am working on creating a kind of gradebook to use online. I'd like to
be able to enter student grades and then give each of them a code to
allow them to view only their own grades. I've tried protecting cell
ranges, but that only stops users from changing the cells. I've also
tried putting one student's grades per sheet, but I can't seem to find
a way to get Excel to ask for a password when navigating to that sheet.


Here's what I'd like to do: Student opens workbook, and there's a cover
sheet with instructions. From there, they navigate to either a single
sheet which asks for a password and then only shows them their grades,
or they click on the sheet with their name and it asks for a password
before they can view it. Is there any way I can do this? I am running
Excel 2002.

Thanks,
Stevie
 
XL was never meant to be a secure application.
Go through these NGs and you will find many password breaker postings and
links.

How about this thought:

YOU give the student their own secret, private passcode, and then post the
grades openly and anonymously, connected only to the passcode.

Enter the various courses down Column A and "freeze" it, then enter the
passcodes across Row1.
Now, all everyone sees is just a list of grades connected to no one person.

To be a bit more sophisticated, you could attach the passcode to a named
range in the name box, which when the student selects the passcode from the
drop down window, will see their grades immediately highlighted.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I am working on creating a kind of gradebook to use online. I'd like to
be able to enter student grades and then give each of them a code to
allow them to view only their own grades. I've tried protecting cell
ranges, but that only stops users from changing the cells. I've also
tried putting one student's grades per sheet, but I can't seem to find
a way to get Excel to ask for a password when navigating to that sheet.


Here's what I'd like to do: Student opens workbook, and there's a cover
sheet with instructions. From there, they navigate to either a single
sheet which asks for a password and then only shows them their grades,
or they click on the sheet with their name and it asks for a password
before they can view it. Is there any way I can do this? I am running
Excel 2002.

Thanks,
Stevie
 
Back
Top