Closing Immediate window

I have added VBE menus that call utilitie macros in a dedicated project (VBE.xls). But some of those utilities clear the VBE menus when they are run on a VBE.xls codepane. I then have to re-run the macro that sets up my VBE menus. That can't be done from within the utilitie. It has to be run AFTER the utilitie has ended. By using SendKeys in the Immediate window, I can re-run Menu_Setup, but it leaves the Immediate window open and in my way. I'm trying to find a way to run Menu_Setup and close the immediate window.

Andy, the problem is that I need to call "CloseImmediateWindow()" from within the immediate window. As soon as it's finished the Immediate Window reopens.

Rob,
I have no control over whether the VBE menus are cleared. They aren't like the menus in Excel. When a codepane, in the project that has Menu_Setup in it, is modified in certain ways, it clears the VBE menus.

I have no problem manually rerunning Menu_Setup, it's just one click somewhere (either in a copepane, or the immediate window). I'm trying to get it to do it automatically. It's just irritating to have to manually close the immediate window when I'm updating my utilities.

Createing a button to rerun Menu_Setup is pointless, because when the menus get cleared ALL the buttons get cleared including the one that would rerun Menu_setup.

foxguy

Why are you altering the menus in the VBE in the first place?

I can't think of any reason you might want/need to do that.

Am I missing something?

PS You do realise that programming code with code can have some security issues.

Norie,
One of the things I do:
ALL my macros have the same format

Please Login or Register  to view this content.

I got tired of typing all that everytime I created a new function. So I created a macro that inserts that code into the active codepane, and created a button in the VBE menus to trigger it.
Now all I do is put my cursor where I want a new function, right mouse click, and select "New Function", then change the function name to what I want. It even selects the function name, so I don't even have to select it, I just start typing. Works great.

But if I insert a new function into the project that contains Menu_Setup, it clears my VBE menus.

I have several utilities (each with it's own button) to do things. I can comment out an entire section of code, Un-comment it back out, insert common statments like "On Error Resume Next", resize codepanes and more. They don't all clear my VBE menus, but the ones that do are irritating.

Why are you using Function?

PS I've got a utility that allows me to comment/uncomment blocks of code - it's on the VBE Edit toolbar, think it's built in.

There also another feature in the VBE - Import/Export...module.

Norie,
I'm at a loss as to your points.

I use function when I need a function, I use sub when I need a sub. I don't understand the question.

I don't argue that I can't do these things without writing modifying code and changing my VBE menus. I'm just saying that it's more convenient to do it my way. That may not be true for you.

I never noticed that there was an Edit toolbar in VBE. The Edit>Indent/Outdent work better than my Edit/Outdent, so I'll have my button call them instead of my Indent/Outdent macros. Thanks

Rob, thanks for the links. I have generally liked developing these tools myself, but I'm always interested in how other people are doing things.

Andy, clever.
It works, but now I have another problem, that I thought was solved. But that's another thread.