Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Situation: I have a workbook with over 30 worksheets, the worksheets have
data entry areas which are unblocked (our data entry person puts the data in those areas) and also formula areas which are blocked, I protect each worksheet individualy to save the formulas from being altered accidently by data entry person. Every month I need to unprotect all 30 worksheets and adjust the formulas for the new month and then protect all 30 worksheets again to make them ready for data entry person again. Question:Is there any way to protect all 30 worksheets in one step instead of 30 times, and unprotect them all 30 in one step instead of 30 times? IREAD ONLY does not solve the problem, because it does not allow the data entry person to work on the same file. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Is there any way that you can protect or unprotect a group of wor. | Excel Discussion (Misc queries) |