Jacob,

Could you clarify if you want your workbook to run only in its own dedicated
Excel Instance or in a normal Instance

Regards,
Peter T

"Jacob" wrote in message
oups.com...
Peter,

I understand that the workbook must be open. I just want it to sit in
the taskbar minimized and not interfere with the user form. I have
also successfully made the workbook invisible, but this cause problems
because I want to be able to open and use other spreadsheets while
using the userform. plus, when I closed the userform, excel still runs
with no easy way of ending the process.

I want this userform to run as much like a stand alone program as
possible. does that make my intent more clear? thanks for your help.

Jacob


Peter T wrote:
Excel/VBA code must reside in a workbook and in order to run it the
workbook
must be open. The workbook could be an Addin which cannot be made
visible
other than changing its IsAddin property.

Regards,
Peter T


"Jacob" wrote in message
ups.com...
I have a spreadsheet that is to be run entirely from a userform. I
currently have it set up so when it is opened, the userform pops up
and
excel is minimized. I also tried adding code that someone had posted,
to minimize the form to the taskbar. It worked well except it messed
up some of my other code. I would get an error every time I tried to
close my form. I have it set up to ask the user if they are sure they
want to close. But for some reason with this minimizing code, I get
an
error telling me that a variable is not declared.

Anyhow, the point is. I want to be able to run this userform as
independent from the spreadsheet as possible, with the ability to
minimize it to the taskbar, and restore it from the taskbar, without
opening the related workbook. I would also like the ability to open
and run other workbooks with the userform open (minimized or not). Is
this possible? thanks.