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?

 

[Nothnless]

If you want to still be able to edit a textbox on a protected sheet just check "Edit objects" in the Protect Sheet dialog window.

 

[dpaton05]

That doesn't allow me to press enter and take me to a new line. If I press enter, the screen goes to the very last row in the workbook, about 11,000. If I scroll up, there is still no new line under the current text in the textbox.

 

[Michael M]

Try using SHIFT +Enter in the TextBox to start a new line

 

[dpaton05]

Still goes to the very last row.

 

[Michael M]

Was the textbox active ?
Did you place the cursor within the texbox before pressing SHIFT + Enter ?

 

[dpaton05]

I clicked in the text box and pressed shift + enter

 

[Michael M]

Ah, is this a ActiveX textBox or a standard TextBox

 

[dpaton05]

A standard text box

 

[dpaton05]

Does it need to be an ActiveX textbox?