How to make Excel Macro executable

Status
Not open for further replies.
N

neoaspilet11

Full Member level 5
Joined
Sep 29, 2005
Messages
277
Helped
29
Reputation
56
Reaction score
8
Trophy points
1,298
Location
Cebu, Philippines
Activity points
4,048
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
 

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
 

Status
Not open for further replies.

Similar threads

Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…