can you lock cells so they can never be changed again

[howsitgoing]

Hi

I have tried to google this , but failed

I am wondering if its possible on excel to Lock cells so the Data can never be changed again after being entered the once , by me or anyone else , i going to be keeping a data record of some electrical testing i will be doing .

cheers
barry

[dilipandey]

Hi barry,

This can be done with cells locking and then protecting the sheets / selected range(s).
You need to consider more details while doing this manually or through a VBA change event, choice is yours.

The logic is -> cells which are blank is unlocked, the moments any data is entered into cell- it will make them locked (via VBA event) and then the respective range (column/row) will be protected or even entire worksheet can be protected. Would be able to better guidance after seeing more details.

Regards,
DILIPandey

<click on below 'star' if this helps>

[howsitgoing]

hi dilipandey

Thanks for the quick reply , vba is new to me
file is attached
I would like to find away , so the data entered cannot be changed again .

thanks
barry

Another solution might be some sort of digital siganture at the end , if you know what i mean

[Fotis1991]

Hi Barry

I give you a way to do this, using just the lock cell and protection Sheet Options.

Hope to helps you.

[dilipandey]

Hi barry,


See the attached file, also look at my comment.

Regards,
DILIPandey

<click on below 'star' if this helps>

[howsitgoing]

Hi barry,


See the attached file, also look at my comment.

Regards,
DILIPandey

<click on below 'star' if this helps>

Hi

thats quite impressive , i have no idea how it works though , but all i have to do is unprotect worksheet for me to change the results is there any way after entering new data It can never be changed

thanks
baz

[dilipandey]

Hi baz,

Since you are the owner of the that excel sheet, you can always change that later, but if you protect the worksheet then other won't.
Also, you would not need to unprotect the worksheet to enter new data if you enter data leaving column A and when you are done with the entry, then only enter the data in column A which is some ID because entering ID will trigger the protect event for that row. Hope this helps and clarifies.

Regards,
DILIPandey

<click on below 'star' if this helps>

[howsitgoing]

Ok

thanks for your time , that is now crystal clear , i have a workbook with worksheets .Can this PAT test worksheet be added to it ?

thanks
barry

[dilipandey]

You are welcome barry. Cheers

Just right click on the respective sheet name of PAT workbook and move it where ever you want. Since the code is with sheet, that will move away with it like a true friend

Regards,
DILIPandey

<click on below 'star' if this helps>

[howsitgoing]

hi

never new excel could move worksheets into other books i have always cut & paste before , very handy tip
but I have tried for a while now trying to move the worksheet to my workbook but failed , i practiced moving it to a blank workbook without any probs , any more tips

i get this error message "Excel cannot insert the sheets into the destination workbook , because it contains fewer row & columns than the source workbook"

cheers
barry

[jeffreybrown]

I see your profile says 2007 which has ~16,000 columns and ~1,000,000 rows.

In 2003 it is (I think) 256 columns and 65,536 rows.

Maybe you are trying to import 2007 into a 2003 sheet. At the top of the spreadsheet you will see the name of the workbook along with Microsoft Excel. If you see the words "Compatility Mode" then you are viewing the sheet in the compressed mode. Hope this makes sense

So in the end, if the sheet you are trying to move has more has than ~1,000,000 rows, you cannot move it to a spreadsheet that only goes to 65,536.

[howsitgoing]

Hi

never really thought about it much before (learning all the time)but i am running excel 2010 & its in 97-2003 compatibility mode , have updated my profile though now

cheers
baz

[jeffreybrown]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

[dilipandey]

Thanks barry,

I had also learn these tips from someone and hence sharing to spread the learning and that is why we all are here.

Cheers

Regards,
DILIPandey

<click on below 'star' if this helps>