I've got a spreadsheet, lets call it "Report", with about 75 tabs, one for each department within our division. Each tab reads from about ten other worksheets. Nothing on the Report document ever needs to be changes by anyone who may read it. I want to lock the entire document so someone can't inadvertently screw up a complicated formula.
I know how to protect specific cells within a tab or for that matter, the entire tab, that's easy but with 75 tabs, it can become laborious. Selecting "Protect Workbook" doesn't seem to lock what I need locked. Other than going tab by tab by tab, Is there a way to lock the entire workbook and protect the cells from change?
TYIA
I know how to protect specific cells within a tab or for that matter, the entire tab, that's easy but with 75 tabs, it can become laborious. Selecting "Protect Workbook" doesn't seem to lock what I need locked. Other than going tab by tab by tab, Is there a way to lock the entire workbook and protect the cells from change?
TYIA