I have a workbook that has about 12 sheets on it. I wanted
to know how I could have each sheet protected. Each sheet
needs to be viewed by all users, but I only want one user
to be able to change information on their sheet only. One
problem that I am having is that when I protect the sheet
it doesn't protect the cells that have pull down boxes.
The data validation cells that have lists cannot be
locked. I also need to know if I can set it so that the
sheets are then protected again when the workbook is
closed. Also is there a way to have one password that can
unlock them all at the same time. Like an admin password.

Thanks,
David