Double Click function then lock on closing worksheet?

[diribarren]

Hello... I am inputting a date into a cell(s) when it is doubleclicked.
I would like some way of locking that date so that when the worksheet is closed
and then re-opened ... you can not adjust the dates already set.
I hope this makes sense! Any suggestions would be greatly appreciated!
THANKS!

OH... I am using the following code to add the date to the cell when it is doubleclicked:

Please Login or Register  to view this content.

.
.
.
.
and on through other ranges I need!

:O)

[:) Sixthsense :)]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[diribarren]

I corrected it ... at least I think this is correct! And I solved this issue on my own!
Thank you!

[:) Sixthsense :)]

Glad you fixed it and thanks for the feedback

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.