vba to lock/protect vba

Hello you beautiful people,

I hope you all are keeping well.

Excel Forum has been my go to point when I get lost so all I can do is thank you all.

The reason I am posting today as this has got me stumped?

I have a master workbook that creates multiple workbooks. In these workbooks there is a worksheet change timestamp.

What I am trying to achieve is to password protect the vba from viewing/amending.

I have never used sendkeys before and the below code isn't working for me?

Sub Test()

SendKeys "%{F11}"
SendKeys "%TE"
SendKeys "{TAB 9}"
SendKeys "{RIGHT}"
SendKeys "{TAB}"
SendKeys " "
SendKeys "{TAB}"
SendKeys "craig"
SendKeys "{TAB}"
SendKeys "craig"
SendKeys "{ENTER}"
SendKeys "%{F4}"

End Sub

I can't f8 the routine so I am unsure why it isn't working as all it is doing is adding the word "craig" to the worksheet. Have I missed something?

I know that this can be cracked via a HEX editor but these are daily spread sheets and the people it will go to won't bother.

Is there an alternative way of locking the VBA code or can I make the above work?

I have attached a sample workbook so you can see my issue.

Any help will be greatly appreciated as per normal