Is it possible to lock a formula on a template without protecting the sheet?

Anonymous
2011-10-06T15:07:52+00:00

I'm trying to lock the formula cells so that they can't be tampered with, but if I protect the sheet it prevents rows from being copied and pasted (even with the "insert rows" option ticked) without unprotecting the sheet, and when the sheet is unprotected the formulas can also be changed, which defeats the object.  I need to have the option of inserting rows but I also want to make sure that the formulas aren't altered.

Is there a way of achieving both objectives?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

8 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2013-10-02T09:00:12+00:00

    It does work... What you do is Unprotect the cells or rows....

    then Protect worksheet ... and do the

    Macro as JL Latham said..

    Then you need to do another couple of macros

    a macro to delete rows

    and or

    a macro to add rows with formula

    So join the macros together...

    All one macro(Unprotect sheet, add rows with formula then protect sheet)

    A great choice idea...

    Was this answer helpful?

    0 comments
  2. Anonymous
    2013-10-02T03:07:24+00:00

    Hope it works as you would like it to.  Thanks for your feedback, it's very much appreciated.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2013-10-02T01:31:03+00:00

    Sounds great JLLatham

    Regards

    Was this answer helpful?

    0 comments