View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John Wirt[_6_] John Wirt[_6_] is offline
external usenet poster
 
Posts: 18
Default Widening the Name Box - need help

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