Disable Form Button After Use

Hi

I created a simple macro to enter the current time in a certain cell, however, after this button is clicked I would like to disable it so you can only enter the time once.

I am quite new to this but this is what I got so far. The Macro is linked to a button which adds a timestamp in another sheet.

Sub Button1()
'
' Button1 Macro
'
' Sheets("Sheet2").Select
Range("C3").Select
ActiveCell.Value = Now()
Sheets("Sheet1").Select


End Sub

Please Login or Register  to view this content.