Programmatically Resize Name Manager Dialog Box

Hi All,

I use Excel's built-in Name Manager a LOT!

Each time Excel is started, the dimensions, column widths etc. of the Name Manager dialog box are reset to default values which (I suppose!) are stored somewhere. The problem is that these default values are unsuitable for me, and I would like to be able to resize the dialog box programmatically.

I've performed a quick check of registry value changes but have been unable to identify where these settings might be stored.

So, does anyone know how to programmatically resize the Name Manager dialog box using e.g. API calls, registry values, other methods???

Regards,

Greg M


P. S. Please note that following rorya's suggestion below, this has also been posted on: https://www.mrexcel.com/board/thread...g-box.1150867/

I suspect the issue is precisely that they are not stored in the registry, and that's why your changes don't persist between sessions. I think it will require API calls to set up a call back to resize the dialog, and its columns, in its window_activate event. The best person I know for this sort of coding is Jaafar Tribak over at MrExcel.