ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Having input the current date in a cell I want to lock it (https://www.excelbanter.com/excel-programming/308111-re-having-input-current-date-cell-i-want-lock.html)

Frank Kabel

Having input the current date in a cell I want to lock it
 
Hi
what are you inserting in this cell

--
Regards
Frank Kabel
Frankfurt, Germany


Jim Mc wrote:
I am running a macro to check info inputted by the form command. I
want to add the date and time at the moment the form is closed. I can
do this but the date and time changes as time moves on. How can I
lock this data?




All times are GMT +1. The time now is 09:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com