Once a long time ago, Tom Ogilvy passed a short code to me that would
essentially simulate a click of the [Compile VBAProject] button in the VBE.
The objective is to force the code in the current module to (re)compile.

I didn't have any luck searching for it. Could someone (if not Tom) please
post this code again? Thanks.

How about:

thisworkbook.VBProject.VBE.CommandBars("Menu Bar"). _
controls("Debug").Controls("Compi&le VBAProject").Execute

--
Regards,
Tom Ogilvy


"quartz" wrote in message
...
Once a long time ago, Tom Ogilvy passed a short code to me that would
essentially simulate a click of the [Compile VBAProject] button in the
VBE.
The objective is to force the code in the current module to (re)compile.

I didn't have any luck searching for it. Could someone (if not Tom) please
post this code again? Thanks.

That's the one! Thanks again Tom.

"Tom Ogilvy" wrote:

How about:

thisworkbook.VBProject.VBE.CommandBars("Menu Bar"). _
controls("Debug").Controls("Compi&le VBAProject").Execute

--
Regards,
Tom Ogilvy


"quartz" wrote in message
...
Once a long time ago, Tom Ogilvy passed a short code to me that would
essentially simulate a click of the [Compile VBAProject] button in the
VBE.
The objective is to force the code in the current module to (re)compile.

I didn't have any luck searching for it. Could someone (if not Tom) please
post this code again? Thanks.