How to make Excel Macro executable

[neoaspilet11]

excel macro executable

Hello Everybody,

I am having an excel applicaiton that has a userform on it and has a VB code. How can I make the applciation such that only the userform and the excel sheet will be displayed and bypassing teh VBcode in running the applcation?

Any help is highly appreciated.

Thanks
neo

 

[jonw0224]

excel to executable

I can't tell what you want exactly, so here goes...

If you want to run an automatic macro, you simply write a macro called "Auto_Activate" and have it call your userform with the "show" command.

If you want to prevent an automatic macro from running, you open excel, then open the excel file with the macro in it while holding down the left SHIFT key.

Hope that helps.

-jonathan

 

[neoaspilet11]

creating exe file for excel macro

jonwo thanks