worksheet protection
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 |
All times are GMT +1. The time now is 08:36 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com