Widening the "name box" - using API

HubbaBuba

New Member
Joined
Oct 27, 2009
Messages
8
Sorry, a rookie, I know zip about the "API" and just need to know the steps to get this task done - please and thank you.
Believe someone mentioned about widening The Defined Name Box (from http://www.cpearson.com/excel/NameBox.aspx )

How do I open and install the code listed there into the API?

Thank you very much.
 

Some videos you may like

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
34,989
Office Version
365, 2019, 2016, 2010
Platform
Windows, MacOS
API = Application Programming Interface.
It is not something that you put code into, it refers to the functions that are used by that code! :)
You need to copy and paste that code into a module in your workbook and then run the WidenNameBox2 sub.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,330
Messages
5,467,977
Members
406,562
Latest member
tobruk

This Week's Hot Topics

Top