XL2003
 

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

XL2003
 

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

XL2003
 

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

XL2003
 

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

XL2003
 

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

XL2003
 

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

XL2003
 

A work around for this:
In the code where you set the value for the text box, first set a cell
somewhere to the same value.

Setting the value of the text box using code (You probably wont want to use
activesheet but its OK for demo):

ActiveSheet.Range("D1") = "My Test"
ActiveSheet.TextBox1 = "My Test"

Now Change event code for text box

Private Sub TextBox1_Change()
TextBox1 = Range("D1")
End Sub

Basically to the user the text box appears locked.


--
Regards,

OssieMac


"JLGWhiz" wrote:

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

XL2003
 

Thank for the suggestion.

What I am really looking for from a MVP is confirmation that ActiveX text
boxes cannot be 'locked' when used on a worksheet.

Paul Smith


"OssieMac" wrote in message
...
A work around for this:
In the code where you set the value for the text box, first set a cell
somewhere to the same value.

Setting the value of the text box using code (You probably won't want to
use
activesheet but it's OK for demo):

ActiveSheet.Range("D1") = "My Test"
ActiveSheet.TextBox1 = "My Test"

Now Change event code for text box

Private Sub TextBox1_Change()
TextBox1 = Range("D1")
End Sub

Basically to the user the text box appears locked.


--
Regards,

OssieMac


"JLGWhiz" wrote:

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