cosmos82
12-04-2010, 03:50 PM
Hey there,
I need a code that prevents cells from changing.
I work in a big company and i must secure that data can not be change once it was entered. My collegues fill into the sheet (Collum A to N) some date. After they did that and close the file all the filled cells should be looked.
I know the code Workbook.BeforeClose. But I don't know how to protect the cell in which the data was filled in.
Any ideas? I Would appreciate your help.
I need a code that prevents cells from changing.
I work in a big company and i must secure that data can not be change once it was entered. My collegues fill into the sheet (Collum A to N) some date. After they did that and close the file all the filled cells should be looked.
I know the code Workbook.BeforeClose. But I don't know how to protect the cell in which the data was filled in.
Any ideas? I Would appreciate your help.