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
|