making a userform work ,oops
 

i have a excel worksheet that has all my functions on it. Now i have made a userform to work with it ,but i'm clueless on how to get the userform to work as an .exe program ,hence i just want the form to load ,and let the excel worksheet hide in the background and do all the work.

making a userform work ,oops
 

the best you can do is

Application.visible = False
userform1.show

in the workbook.open event. The excel application will be visible before
that command is executed.

You can't create an Exe. I assume you mean operate like an Exe.

--
Regards
Tom Ogilvy


"scott t" wrote in message
...
i have a excel worksheet that has all my functions on it. Now i have
made a userform to work with it ,but i'm clueless on how to get the
userform to work as an .exe program ,hence i just want the form to load ,and
let the excel worksheet hide in the background and do all the work.

making a userform work ,oops
 

thanks ,that worked ,yes i was looking for a way to run it like an .exe program ,well i guess i need to study some more and find the right way to run this program i have.