Single use macro in command button

[JamesT1]

Hi guys

Below is the code assigned to a button for inputing the time when we book a driver out, what I am looking for is a way for the button to only be used once... so if a driver books out at 08:00 then the time wont change if the button is pressed at another time

Please Login or Register  to view this content.

Thanks for your help

[mdbct]

Check F3 for a value and if the is one, exit the sub without doing anything to the sheet.

Please Login or Register  to view this content.

[JamesT1]

mdbct

just what I need,,, works a treat, thank you for your help