Protect group of cells with userform log in

[demureecho]

I apologize if this has been previously answered, but I've been Googling for an hour and can't find a solution.

I've created a log in/password page with a userform so that multiple users can access the workbook using their own password. I have a group of cells on several sheets in the workbook that needs to be locked to all users who log in except for the admin. All logged in users must be able to view the cells, but only the admin can edit them. Is this possible, and if so how would I accomplish it?

Code/detailed instructions is preferred because I am very new to VBA. Thank you for your help!

[SZBELL]

record this and add it to your marco

http://www.lytebyte.com/2009/06/15/h...rows-in-excel/

[demureecho]

Thank you for your reply, however it's not quite what I'm looking for. Is there a way to tie the authority to edit the locked cells into the initial log in? What would be ideal is that when UserA logs in, they cannot edit cells B79:AF83 - however when Admin logs in they can.

Some background: This is to be used for a workbook that tracks each employee's daily productivity. Each day the Admin enters the previous day's processing total in the locked cells. The employee needs to be able to see the totals, but not edit them.

There are over 100 employee workbooks that need to be updated daily, and my boss will not be super thrilled if she has to log in to each workbook, unprotect the sheet, and then re-protect it every time.

I was thinking of adding an authority column to my "config" sheet (where I have my user name and passwords), but I have no idea how I'd code the macro to recognize the authority and lock/unlock the cells accordingly. Any help is appreciated. Thanks!