On a worksheet I have placed a TextBox from the ControlToolbox menu. I have
set the locked property to True, however I am amazed that I can still edit
the text that is insdie the box.

I have actually written code on a button which should alloow the user to
change the text, but I cannot seem to find anyway of stopping the user from
just typing into the text box.

Why is the locked property not working?

Paul Smith

Are you still in Design Mode? On the tools bar press the Triangle to exit
design mode.

"Paul W Smith" wrote:

On a worksheet I have placed a TextBox from the ControlToolbox menu. I have
set the locked property to True, however I am amazed that I can still edit
the text that is insdie the box.

I have actually written code on a button which should alloow the user to
change the text, but I cannot seem to find anyway of stopping the user from
just typing into the text box.

Why is the locked property not working?

Paul Smith

No I am not still in design mode.

I have also tried applying protection to the page to see if this invokes the
locking - it does not.



"Joel" wrote in message
...
Are you still in Design Mode? On the tools bar press the Triangle to exit
design mode.

"Paul W Smith" wrote:

On a worksheet I have placed a TextBox from the ControlToolbox menu. I
have
set the locked property to True, however I am amazed that I can still
edit
the text that is insdie the box.

I have actually written code on a button which should alloow the user to
change the text, but I cannot seem to find anyway of stopping the user
from
just typing into the text box.

Why is the locked property not working?

Paul Smith

How about disabling the Textbox
Textbox1.Enable = False

"Paul W Smith" wrote:

No I am not still in design mode.

I have also tried applying protection to the page to see if this invokes the
locking - it does not.



"Joel" wrote in message
...
Are you still in Design Mode? On the tools bar press the Triangle to exit
design mode.

"Paul W Smith" wrote:

On a worksheet I have placed a TextBox from the ControlToolbox menu. I
have
set the locked property to True, however I am amazed that I can still
edit
the text that is insdie the box.

I have actually written code on a button which should alloow the user to
change the text, but I cannot seem to find anyway of stopping the user
from
just typing into the text box.

Why is the locked property not working?

Paul Smith

That will disable the text box shading it's contents.

What I am asking is how or if i can make an activeX text box work on a
worksheet the same way it does on a user form. On a user form, locking the
control has an effect, on a worksheet it does not seem to.

Can anyone confirm this?



"Joel" wrote in message
...
How about disabling the Textbox
Textbox1.Enable = False

"Paul W Smith" wrote:

No I am not still in design mode.

I have also tried applying protection to the page to see if this invokes
the
locking - it does not.



"Joel" wrote in message
...
Are you still in Design Mode? On the tools bar press the Triangle to
exit
design mode.

"Paul W Smith" wrote:

On a worksheet I have placed a TextBox from the ControlToolbox menu.
I
have
set the locked property to True, however I am amazed that I can still
edit
the text that is insdie the box.

I have actually written code on a button which should alloow the user
to
change the text, but I cannot seem to find anyway of stopping the user
from
just typing into the text box.

Why is the locked property not working?

Paul Smith

The effect that I got with a textbox on a protected sheet and locked was that
i could not access the properties window to change any of the properties,
although I could change the text. I believe that is the design.

"Paul W Smith" wrote:

That will disable the text box shading it's contents.

What I am asking is how or if i can make an activeX text box work on a
worksheet the same way it does on a user form. On a user form, locking the
control has an effect, on a worksheet it does not seem to.

Can anyone confirm this?



"Joel" wrote in message
...
How about disabling the Textbox
Textbox1.Enable = False

"Paul W Smith" wrote:

No I am not still in design mode.

I have also tried applying protection to the page to see if this invokes
the
locking - it does not.



"Joel" wrote in message
...
Are you still in Design Mode? On the tools bar press the Triangle to
exit
design mode.

"Paul W Smith" wrote:

On a worksheet I have placed a TextBox from the ControlToolbox menu.
I
have
set the locked property to True, however I am amazed that I can still
edit
the text that is insdie the box.

I have actually written code on a button which should alloow the user
to
change the text, but I cannot seem to find anyway of stopping the user
from
just typing into the text box.

Why is the locked property not working?

Paul Smith