Locking all Formulas on a spreadsheet

Hi All,

I am currently working on a new spreadsheet for my company in which the workbook has various TABS for each department in which data is entered and formulas are in place to calculate totals on a daily, weekly and monthly basis.

On top of this I have other TABS showing the STATS for all departments for weekly monthly and annual figures.

All the TABS in the workbook contain at least 1 if not numerous formulas, and in fact the Stats tabs are only for pulling data from the other sheets.

I understand you can unlock cell ranges for data entry and lock other cells but I can only see this in "ranges".

What I would like to do is protect every formula on the workbook as they are so extensive it would take me as much time to protect each/give access to certain ranges as it did to create the workbook in the first place!

Can anyone tell me if this is possible, or am I best to lock the whole workbook and only allow permissions to certain people within each department?

Thanks all!!

~Sat~

Hi Cat, welcome to the Forum.

Be sure to read through the Forum Rules that you agreed to when you registered...so you can use and follow them effectively. For instance, you'll need to edit that post above and revise the title to properly define the topic. (Rule #1)

Perhaps "Locking all Formulas on a spreadsheet"

This is doable, fix that title and I can show you some ideas.
EDIT the original post, GO ADVANCED...

hi and welcome to the board
Check this link

That's the way I would do it. The Special Cells property is very powerful.

1) Select all cells on sheet
2) Press CTRL-1 to open the Format Cells dialog
3) On the Protection tab, uncheck the LOCKED option
4) Click OK

Now all cells are unlocked

5) Now press F5 and click on SPECIAL
6) Select Constants
7) Click OK
8) Ctrl-1 to open the Format Cells dialog again
9) On the Protection tab, click on the LOCKED option to select it
10) Click OK

11) Last step, protect the worksheet.

If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].


(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated. It is found across from the "time" in each of our posts.)