Normally I can rename text boxes and buttons by changing the name in the
Name Box. But sometimes I can't. In this instance I'd like them to have the
same names as they have on another sheet. This so my clearing macro can be
the same for both sheets, just have the correct sheet selected. Sometimes I
can make the names the same. Sometimes I can't. Is there another way to
rename them?

Don <donwiss at panix.com.

What's the situation when you can't rename them?

Is the worksheet protected?
Do you have worksheets grouped?
Are you sure you hit enter after you typed the name in the namebox?



Don Wiss wrote:

Normally I can rename text boxes and buttons by changing the name in the
Name Box. But sometimes I can't. In this instance I'd like them to have the
same names as they have on another sheet. This so my clearing macro can be
the same for both sheets, just have the correct sheet selected. Sometimes I
can make the names the same. Sometimes I can't. Is there another way to
rename them?

Don <donwiss at panix.com.

--

Dave Peterson

On Sat, 25 Dec 2004, Dave Peterson wrote:

Don Wiss wrote:

Normally I can rename text boxes and buttons by changing the name in the
Name Box. But sometimes I can't. In this instance I'd like them to have the
same names as they have on another sheet. This so my clearing macro can be
the same for both sheets, just have the correct sheet selected. Sometimes I
can make the names the same. Sometimes I can't. Is there another way to
rename them?

What's the situation when you can't rename them?

Is the worksheet protected?
Do you have worksheets grouped?
Are you sure you hit enter after you typed the name in the namebox?

No, no, and no. I can rename them, but not to the same name they have on
another sheet. This is something that I usually can do. Anyway, I wrote a
two line macro to rename them.

Don <donwiss at panix.com.

Did you really mean to answer no to that third question <vbg?

I'm not sure why you could rename a textbox in code, but not via the user
interface.

One more question...

If the textbox is from the control toolbox toolbar, make sure you go into Design
Mode first (an icon on that same toolbar).


Don Wiss wrote:

On Sat, 25 Dec 2004, Dave Peterson wrote:

Don Wiss wrote:

Normally I can rename text boxes and buttons by changing the name in the
Name Box. But sometimes I can't. In this instance I'd like them to have the
same names as they have on another sheet. This so my clearing macro can be
the same for both sheets, just have the correct sheet selected. Sometimes I
can make the names the same. Sometimes I can't. Is there another way to
rename them?

What's the situation when you can't rename them?

Is the worksheet protected?
Do you have worksheets grouped?
Are you sure you hit enter after you typed the name in the namebox?

No, no, and no. I can rename them, but not to the same name they have on
another sheet. This is something that I usually can do. Anyway, I wrote a
two line macro to rename them.

Don <donwiss at panix.com.

--

Dave Peterson

On Sat, 25 Dec 2004, Dave Peterson wrote:

If the textbox is from the control toolbox toolbar, make sure you go into Design
Mode first (an icon on that same toolbar).

I have never used a control toolbox text box. Generally I try to avoid the
extra complication of the controls when I can. In this case I don't know
what additional features I'd get by using one, though I suppose I would be
able to tell where it was located on the sheet.

I'm having a bit of a problem now with a combo box from the control
toolbox. I just haven't written out the problem yet to post here. I'll do
so tomorrow, but for now it is getting late here in Brooklyn.

Don <donwiss at panix.com.