Expand default size of Define Name dialog box

batman37

New Member
Joined
Jul 21, 2007
Messages
10
I raise the Define Name dialog box frequently; it displays up to 10 named ranges without scrolling. Most of my applications have more than 10 named ranges, often a lot more, thus requiring scrolling to see most of them. Is there a way to change the default height so that it always comes up showing 25 ranges? Perhaps a setting in the Registry. Or is the 10-row default hard-coded?

Thanks for any solution or words of wisdom.
 

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

Jaafar Tribak

Well-known Member
Joined
Dec 5, 2002
Messages
8,203
Office Version
  1. 2016
Platform
  1. Windows
I raise the Define Name dialog box frequently; it displays up to 10 named ranges without scrolling. Most of my applications have more than 10 named ranges, often a lot more, thus requiring scrolling to see most of them. Is there a way to change the default height so that it always comes up showing 25 ranges? Perhaps a setting in the Registry. Or is the 10-row default hard-coded?

Thanks for any solution or words of wisdom.

You can easily resize the Define Name dialog to full screen just by double-clickng its titlebar.
 

batman37

New Member
Joined
Jul 21, 2007
Messages
10
Thanks, Jaafar.
I was not aware of that feature, which presumably applies to any and all dialog boxes. That said, I would much rather be able to see my worksheet while the Define Name dialog box is up; thus my interest in extending its vertical height without making it any wider. Yes, I can drag the bottom down, and I often do that. But I would much rather have the bottom much lower by default. Is there a way to do that?
 

Jaafar Tribak

Well-known Member
Joined
Dec 5, 2002
Messages
8,203
Office Version
  1. 2016
Platform
  1. Windows
AFAIK, there is no way to set the default height .

I honestly don't see why one would want to do this when it is so easy to drag the dialog bottom down with a simple mouse gesture.

One could set the height via some complicated api code but frankly, I don't think it would be worth the effort.

Regards.

Regards.
 
Last edited:

batman37

New Member
Joined
Jul 21, 2007
Messages
10
Well, you're welcome to your opinion. That said, I did a Registry search on "Define Name" - it came up empty, so I have no choice to accept that what I would like to do can't be done. It's not a show stopper. Thanks for your responses.
 

Watch MrExcel Video

Forum statistics

Threads
1,129,574
Messages
5,637,162
Members
416,959
Latest member
Mohzein

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top