I am using Excel 2003. I have a dash board where students enter a user name and password to see their page only. Is there Some type of code that would allow me the instructor to Unlock all sheets in the work book for editing. or do i have to use the tool menu and the protection option for each sheet?
I lock the same cells for every students sheet so if i could find some type of macro lock that would lock the same cells or range of cells in every sheet for and would allow a password to unlock those cells.
I am currently using a code on each sheet that locks the unlocked cells once any information is put in.
I guess I was thinking my new code might be a workSheet code.
If anyone has any ideas please let me know.
thanks Mike
I lock the same cells for every students sheet so if i could find some type of macro lock that would lock the same cells or range of cells in every sheet for and would allow a password to unlock those cells.
I am currently using a code on each sheet that locks the unlocked cells once any information is put in.
I guess I was thinking my new code might be a workSheet code.
If anyone has any ideas please let me know.
thanks Mike