Executing code when a textbox is selected

[dpaton05]

How to I execute code if a textbox is clicked in so the cursor appears on a locked sheet?

I want to unprotect my worksheet when a textbox has the cursor placed in it to type and protect it when the user has finished typing in it.


If you can't do that, can you protect a sheet but unprotect a textbox, allowing you to press enter to go to a new line while the sheet is protected?

 

[Michael M]

When you protect the worksheet make sure you check the "Edit Objects" box before completing the protect.

 

[dpaton05]

Thanks Michael