Lock Textbox From Being Changed

[AaronC]

Good day,

I have a form in a workbook that has macros attached via buttons. The intention is that as you hit the revise button it creates a virtually identical sheet, renaming it as a copy in the same workbook, clearing certain fields...etc...I then have it "lock/protect" the previous revision sheet so the history can't easily be corrupted. Everything works with the exception of the forms textbox...it won't lock (more to the point I can't figure out how to lock it). Can you protect a forms textbox even?

Thanks in advance
Aaron

[Simon Lloyd]

Hi, Right click the TextBox and choose properties and change the Locked property to True!

Regards,
Simon

[AaronC]

Just needed to do this...thanks though!

With ActiveSheet.TextBoxes 
    ActiveSheet.TextBoxes.Locked = True 
    ActiveSheet.TextBoxes.LockedText = True 
End With