Text Box

[Guest]

Hi,

I was entering directions into a text box which is located near other
calculations.
It is annoying that the text box, will move around when you click on it. Is
there any way to set the text box so that you cant move it when you are
clicking around?

Thanks

 

[Dave Peterson]

It sounds like you used a textbox from the drawing toolbar.

If you select the textbox, rightclick on it and choose format textbox,
then Protection tab
You can protect the location and the contents.

But you have to protect the worksheet for this to take effect.
(tools|protection|protect sheet)

Maybe using the textbox from the control toolbox toolbar would be easier.