Matt_Straya
Member
Hi,
I have tried to figure out how to lock the id number on my sheet but I just can figure it out.
When you open the sheet it asks you to make sure there is a number in B2. On my "Sheet1" tab there is also a button to insert a unique ID number. What I would like is to lock the number in B2.
When a Risk description is entered a unique number is put in the adjacent cell, giving it a unique number - all that bit works fine. I just need to be able to lock (and maybe unlock) B2 once the sheet starts being populated/used.
I have tried to figure out how to lock the id number on my sheet but I just can figure it out.
When you open the sheet it asks you to make sure there is a number in B2. On my "Sheet1" tab there is also a button to insert a unique ID number. What I would like is to lock the number in B2.
When a Risk description is entered a unique number is put in the adjacent cell, giving it a unique number - all that bit works fine. I just need to be able to lock (and maybe unlock) B2 once the sheet starts being populated/used.