Question Locked
Multiple worksheet protection
0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
How can I protect multiple worksheets in one workbook simultaneously? I have 20 tabs in one Workbook with certain cells "unprotected". If I protect the workbook, that does not protect the cells that are "protected" within each of the 20 tabs (worksheets). It is time consuming to enter the 20 tabs separately to assign a worksheet protection name in order for the cell protection to take place.
Vic Celadon
Director, Accounting - Scotland Memorial Hospital, Lauringburg, NC