VBA code in a macro to delete the macro once executed? like time enter?

[Caveman1964]

Hi,
Wondering how to code a macro so it is no longer usable once used.
here is my small macro, I want them to click it then it can't be used or cell changed.

Sub enterstopdown()
Range("H24").Value = Now()
End Sub

so this puts date and time in cell. then I don't want that changed ever. like they can't accidentally click it again or change the time/date in cell.
Appreciate any help on this!
Thanks

 

[arunsjain]

Hi

Refer to following links

https://www.mrexcel.com/forum/excel-questions/81595-disable-macros-after-one-has-been-run.html



https://excel.tips.net/T003123_Self-Deleting_Macros.html

Cheers!!

 

[Caveman1964]

Perfect thanks!