Name Manager

[LisaGreen]

This is mostly for Jan Karel...

Eerst... Beste Wensen!!!

For years I thought people were saying Best Events!! Sooo I'll say that too... Best Events Jan Karel.

I have a tiny prob with the name manager... It's persistent between sessions in the VBE. That is... it comes up as a toolbar in the vbe. If I close it it's gone for that session. When I reopen a workbook... there it is in the VBE again. I can only get rid of it if I disable the add in... which I don't really want to do 'cauze it's a good 'un. :-)

I've started a thread on the code cage about it. There's a pic of the VBE there.
http://www.thecodecage.com/forumz/micro ... names.html" onclick="window.open(this.href);return false;
Any help??

TIA
Lisa

[HansV]

Jan Karel will have to confirm this, but I suspect that the toolbar is created anew each time the add-in is loaded.

If the toolbar really bothers you, you could create a macro in your Personal Macro Workbook that hides the toolbar, and assign this macro to a Quick Access Toolbar button:

Code: Select all

Sub HideNMToolbar()
    On Error Resume Next
    Application.VBE.CommandBars("RangeNames").Visible = False
End Sub

You could even run it automatically when Excel is started, by calling it from the Workbook_Open event procedure in the ThisWorkbook module of your Personal Macro Workbook:

Code: Select all

Private Sub Workbook_Open()
    Application.OnTime Now + TimeSerial(0, 0, 1), "HideNMToolbar"
End Sub

The event procedure calls HideNMToolbar with a slight delay to give all add-ins the time to load.

Important: You must trust programmatic access to the Visual Basic project, otherwise HideNMToolbar won't work. You can set this in File > Options > Trust Center > Trust Center Settings... > Macro Settings:

S0488.png

[Jan Karel Pieterse]

Hi Lisa,

Indeed, the toolbar is recreated when you reload Excel (in fact, that is the only way to have toolbars in the VBE).
Is it in your way that much?

[Jan Karel Pieterse]

I have updated Name Manager so it remembers the visible state.

[HansV]

Thank you, Jan Karel!

[LisaGreen]

Cool!!!!... Thanks everyone. Hans... Over on the codecage I did say to Jan Karel that it was only a little teeny thing.... Jan Karel... thank you soooo much for bothering!!

Where do you save the state?

Hugs... Lisa

[Jan Karel Pieterse]

Registry:
HKEY_CURRENT_USER\Software\VB and VBA Program Settings\Name Manager 4.2\VBECommandbar

[LisaGreen]

Thanks Jan Karel... Any news on the redo of the indenter yet please??

Lisa

[Jan Karel Pieterse]

No, unfortunately not. And I don't "own" the code, so...

[LisaGreen]

Boo Hoo!!!... I've tried to email Stephen Bullen a number of times about various things and never gotten a reply. Do you know if he's okay or still active around Excel? Has he retired maybe?

Lisa

[Jan Karel Pieterse]

Stephen is not active in the Excel community any more. But I see you got a response from him after all :-)