Hi, this is my first time here... I think you guys are great!
I require code that will (after saving the file and again before closing the file) loop through all worksheets in the workbook, lock any cells that contain formulas (if they are not already locked) and protect all worksheets.
The idea is to reset the entire file to be protected so the user doesn't forget to manually lock/protect before closing in case a different user is opening the file and doesn't know how to protect, etc.. Also by having it re-protect when saves are done, it doesn't leave the spreadsheets as vulnerable, because the user will have to manually unprotect the sheet(s) to make a formula change.
Just wondering how protection/locking etc. affects a user inserting rows that change the range referred to in some of the formulas?
Thanks,
Eliz
I require code that will (after saving the file and again before closing the file) loop through all worksheets in the workbook, lock any cells that contain formulas (if they are not already locked) and protect all worksheets.
The idea is to reset the entire file to be protected so the user doesn't forget to manually lock/protect before closing in case a different user is opening the file and doesn't know how to protect, etc.. Also by having it re-protect when saves are done, it doesn't leave the spreadsheets as vulnerable, because the user will have to manually unprotect the sheet(s) to make a formula change.
Just wondering how protection/locking etc. affects a user inserting rows that change the range referred to in some of the formulas?
Thanks,
Eliz