Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Passowrd Protecting
I currently have 8 sheets within a workbook which are protected, on each
sheet I have some locked and unlocked cells. Each worksheet is for each day of the week plus a totals sheet, therefore the layout for each sheet is identical. At present If I need to make an amendment to any of the locked cells I have to unprotect every sheet make the change and then proect every sheet. Is there anyway of proecting ALL the sheets at once and unprotecting them all at once as this would reduce the time it takes. Regards The Rook |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protecting more than one worksheet in one workbook | Excel Discussion (Misc queries) | |||
Locking Cells ... Without Protecting Sheet | Excel Discussion (Misc queries) | |||
Locking Cells ... Without Protecting Sheet | Excel Discussion (Misc queries) | |||
Protecting Sheets | Excel Discussion (Misc queries) | |||
Leave list box unprotected while protecting worksheet | Excel Discussion (Misc queries) |