I'm a total newbie to this. When the normal rate on the worksheet has to use
a substitute rate, I have an input box prompt for the substitute value. I
want the value to write to a certain cell to be used in a calculation. The
macro is doing what I want except writing the input value to the cell - H14.
What am I doing wrong?

ActiveSheet.Unprotect
Range("E14").Select
ActiveCell = "TTD Rate Override Applies"
myNum = Application.InputBox("Enter TTD Rate Override")
Range("h14").Select
ActiveSheet.Protect