I would like to install the code for widening the Name Box that is on Chip
Pearson's web site (http://www.cpearson.com/excel/NameBox.htm)

I copied the declarations and WidenNameBoxDrop2 procedure to a new module I
created in Personal.xls.

The WidenNameBoxDrop2 procedure is then called by an event procedure I
created in the ThisWorkBook object of PERSONAL.XLS:

Private Sub Workbook_Open()
Call WidenNameBoxDrop2
End Sub

The baisc problem is that nothing happens. Even if I step through the
procedure, the Name Box does not change.

What is wrong?

John Wirt

Hi John,

I think you got it wrong. It does not widen the Name Box itslef! It
only widens the dropdown display width.

Click on the down arrow on the name box and you will see that when it
displays the names, the width of the display box is widened. (You must
have at least one name defined to see this.)

Sharad



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Hi John,

See multiple responses to your post 3 days ago:

http://tinyurl.com/54knd

Did none of these help?


---
Regards,
Norman



"John Wirt" wrote in message
...
I would like to install the code for widening the Name Box that is on Chip
Pearson's web site (http://www.cpearson.com/excel/NameBox.htm)

I copied the declarations and WidenNameBoxDrop2 procedure to a new module
I
created in Personal.xls.

The WidenNameBoxDrop2 procedure is then called by an event procedure I
created in the ThisWorkBook object of PERSONAL.XLS:

Private Sub Workbook_Open()
Call WidenNameBoxDrop2
End Sub

The baisc problem is that nothing happens. Even if I step through the
procedure, the Name Box does not change.

What is wrong?

John Wirt

Probably not. I think we were all misunderstanding the question, and that
Sharad has understood what John is getting.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Norman Jones" wrote in message
...
Hi John,

See multiple responses to your post 3 days ago:

http://tinyurl.com/54knd

Did none of these help?


---
Regards,
Norman



"John Wirt" wrote in message
...
I would like to install the code for widening the Name Box that is on
Chip
Pearson's web site (http://www.cpearson.com/excel/NameBox.htm)

I copied the declarations and WidenNameBoxDrop2 procedure to a new
module
I
created in Personal.xls.

The WidenNameBoxDrop2 procedure is then called by an event procedure I
created in the ThisWorkBook object of PERSONAL.XLS:

Private Sub Workbook_Open()
Call WidenNameBoxDrop2
End Sub

The baisc problem is that nothing happens. Even if I step through the
procedure, the Name Box does not change.

What is wrong?

John Wirt

Thank you. Got them now.
Yes, the code did work when I open the Name Box. I misunderstood.
Will try the Add-in, too.
John


"Norman Jones" wrote in message
...
Hi John,

See multiple responses to your post 3 days ago:

http://tinyurl.com/54knd

Did none of these help?


---
Regards,
Norman



"John Wirt" wrote in message
...
I would like to install the code for widening the Name Box that is on
Chip
Pearson's web site (http://www.cpearson.com/excel/NameBox.htm)

I copied the declarations and WidenNameBoxDrop2 procedure to a new
module
I
created in Personal.xls.

The WidenNameBoxDrop2 procedure is then called by an event procedure I
created in the ThisWorkBook object of PERSONAL.XLS:

Private Sub Workbook_Open()
Call WidenNameBoxDrop2
End Sub

The baisc problem is that nothing happens. Even if I step through the
procedure, the Name Box does not change.

What is wrong?

John Wirt

You are correct. I got it wrong. Thanks.
John


"Sharad" wrote in message
...
Hi John,

I think you got it wrong. It does not widen the Name Box itslef! It
only widens the dropdown display width.

Click on the down arrow on the name box and you will see that when it
displays the names, the width of the display box is widened. (You must
have at least one name defined to see this.)

Sharad



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!