Multiple worksheet protection

By vic.celadon ·
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

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Related Discussions

Related Forums