I have a spreadsheet with many formulas I would like to keep protected from coworkers in other departments who delete the formulas due to lack of understanding of Excel. Originally I went to Edit - Go To - Special - Formulas and would highlight all the cells with formulas and protect the sheet from there. However, it was noticed that rows/columns could not be inserted once these formulas were protected. I need to be able to allow them to insert rows/columns as needed.
There are many worksheets. Any suggestions or maybe a macro to help this process go quicker?
There are many worksheets. Any suggestions or maybe a macro to help this process go quicker?