Force code to compile
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.
|