View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
stindle stindle is offline
external usenet poster
 
Posts: 4
Default Forms ran as EXE

Is there a way to convert a form to an EXE?
I have a user form, I want the user to open, without them seeing Excel.
Should I just use open events? When I do, it still asks me if i want to
enable the macros before it even looks at the form.

Also, when the form is closed, if the form is the only workbook open, I want
to use Application.Close, else Workbooks.Close
What is the code to determine how many workbooks are open so I can write the
if statement? I don't want to leave any loose ends in my coding, so I want to
close Excel if my form opened it, but don't want to close it if the user is
has another file open. Might not be needed if I can convert the form to EXE.
but would be nice to know for later.

TIA
Steve