Selective Protection of a Worksheet

  • Thread starter Thread starter DCMyers1
  • Start date Start date
D

DCMyers1

Can anyone please tell me if it is possible to protect a worksheet from editing
whilst still allowing formulae to change the information within the same
worksheet with data acquired from either other sheets within the same worksheet
or from other worksheets entirely.

The reason for this is that I have set up an Excel worksheet to calculate
marks, averahges, summaries, track targets, etc but the other staff keep trying
to enter the data on top of where I have put formulae. I tried protecting the
worksheet but it just prevented it from updating when the formulae picked up
ammended data from elsewhere.

I would be grateful for any help as I am gettig fed up of correcting the
problems that others have unwittingly caused.


Thanks

David
 
David,

It is difficult to envisage your problem. On sheet1 I entered a simple
formula in A1
Code:
--------------------
=B1*Sheet2!A1
--------------------


I then entered a constant in B1 before selecting the whole sheet and
locking and hiding the cells. I protected the sheet and removed all
ability to select any cells.

I then changed the data in A1 on Sheet2 and Sheet1 updated OK as I
would expect :confused:

If it would help I am willing for you to post me a copy of your sheet.
 
DCMyers1,

You can use Format/Cells/Protection to "lock/unlock" any cells
on the sheet that you want to. When you protect the worksheet
Tools/Protection/Protect Sheet, only those cells that are unlocked will
be able to be changed by the user.
Any formulas that you have, whether locked or unlocked, will update
when any cells they are referencing are changed.

John
 
Back
Top