I guess while I was typing, so was NickHK - and it causes me to add this:
he's right in that people would be able to enter formulas into unlocked
cells. If your intent is to prevent adding formulas anywhere, then perhaps a
combination of my recommendation and a modification of his to examine the
cells you know to be unlocked would work for you.

"JLatham" wrote:

You need to use worksheet protection to keep cells you don't want to be
altered from being altered. Cells that are Locked cannot be altered once
worksheet protection is enabled. All cells are locked by default in a new
workbook, so your first task is to identify all cells that you DO want your
users to be able to use and unlock them. This is done via Format | Cells
and clearing the Locked option on the [Protection] tab in that dialog. Any
cells that are associated with controls and any that are altered via VBA
coding will also need to be unlocked.

Workbook/worksheet protection is accessed through Tools | Protection.

Keep in mind that even using a password for protection is not 100% in Excel.
There are lots of workbook/worksheet password cracking programs available
that are effective and fast! But for the typical use, they suffice.

"news.freedom2surf.net" wrote:

Hi,

I have a workbook which I want to prevent users from entering formulae
globally across the entire workbook.

There are however formuale already entered into the workbook but want to
prevent any new formulae being entered.

Can this be accomplished? How would I do this?

Many thanks.

Ian E.