Any help would be appreciated. I am thinking if this is possible. I have all
the records set up. Students have their ID number on Col A. Students name on
Col B and Grades on Col C. Col D sorts the grade automatically using macro.
This is my dilemma. I want to let my students see their records on the
network. Let say if they enter their ID number on a switchboard, they will
see their name, rank and grades. Is that possible with excel? Thanks.

boogie,

Is that possible with excel?
Anything is possible with Excel

Let say if they enter their ID number on a switchboard
Do they know each others ID number??
Will you need a password too?
Will you assign and manage the passwords or will they need
to be able to change their passwords themselves??

This is more of a project than a question so I can't answer
everything here, but I'll give you a start. Take it one step at
a time and keep posting back when you get stuck and I'm
sure that someone will help you get to your final solution.

One scenario.......(for ID# only, no passwords)
Take your data sheet and make it VeryHidden
(that way no one can see it, or unhide it).
In the Workbook_Open event, call up a UserForm
On that UserForm will be a TextBox to put in an ID#.
When a valid ID# is entered, Labels on that UserForm
will populate with whatever data that you have for that
ID#.

What you want to do can be done.

John



"boogie" wrote in message
...
Any help would be appreciated. I am thinking if this is possible. I have
all
the records set up. Students have their ID number on Col A. Students name
on
Col B and Grades on Col C. Col D sorts the grade automatically using
macro.
This is my dilemma. I want to let my students see their records on
the
network. Let say if they enter their ID number on a switchboard, they will
see their name, rank and grades. Is that possible with excel? Thanks.