Results 1 to 3 of 3

Thread: Locking cells
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Jan 2017
    Posts
    51
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Locking cells

    Hi,

    I have a spreadsheet with some formulas in to represent a receipt.

    I want to be able to lock the cells with formulas. I think this is easy enough.

    My trouble is I want to lock some cells to accounting GBP currency. basically so a figure can be entered but so that somebody cannot delete this form. Can this be done. When ever I lock it I can't seem to change anything.

    I'm just worried when somebody uses it to enter a figure if using an old receipt as a template they may delete the cell to put a new figure in. Problem is it then deletes the accounting format.....

    Any help is much appreciated.

  2. #2
    New Member
    Join Date
    May 2019
    Location
    New Jersey USA
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Locking cells

    Hello,

    How about "validation" function?

  3. #3
    Board Regular
    Join Date
    Jan 2017
    Posts
    51
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Locking cells

    The validation function doesn't allow you to stop people from clicking in the cell and hitting delete (and it deleting the accounting format).... Not unless I'm missing something?

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •