Good evening, from Greece.
I would like to ask:
How can "lock" a cell, since the make a record.
Thus, if cell A1, write 1 (or anything else I want), then lock and not let me write anything again.
I want to be or the entire spreadsheet or a range of cells PARTICULAR.
Is it possible?
Regards
Fotis.
I am proud that i am Greek.
Just to know every one.We Greeks, we are nοt proud of our politicians. Υou?
Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
My Avadar picture, is from Athens Acropolis.
http://www.theacropolismuseum.gr
http://www.visitgreece.gr/
Hi Fotis1991,
Yes it possible
with a work sheet change event
to unprotect sheet
to lock the tcell arget cell
then lock the sheet again
regards pike
If the solution helped please donate here to the RSPCA
Sites worth visiting;
J&R Solutions - royUK
AJP Excel Information - Andy Pope
Spreadsheet Toolbox
VBA for smarties - snb
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks