Stop User Editing Some Excel Cells

  dave_and_confused 09:55 31 Aug 2005
Locked

I have set up an Excel spreadsheet for a client to calculate his invoicing.

However as he is reliant on this to be correct i want to prevent him from being able to edit (accidentally or on purpose) the cells containing the formula.

Is there a simple method? I can see instructions to protect and entire worksheet but not cells.

  dave_and_confused 09:58 31 Aug 2005

Right click the cells to Unprotect, Format Cells, Protection tab, Untick Locked.

Do this for all the cells to unlock.

THEN protect the sheet.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

AMD Radeon Adrenalin release date, new features, compatible graphics cards

Turn a photo into 16-bit pixel art

iMac Pro release date, UK price & specs

Comment suivre le parcours du père Noël ?