W
Webtechie
Hello,
I've created an Excel application using userforms that is actually pretty
good. I hide the Excel application and using the userforms, you can't really
tell you are in Excel. Ok. Great.
However, if the user has Excel open already, the Excel Application that I
wrote snags and hides everything.
How do you code a workbook in VBA so that when it opens, it opens in its own
instance?
If I then to use application.visible = false, will that just hide the Excel
instance of my application's workbook?
I hope I am conveying what I am trying to do well enough?
I only want to hide the latest instance (my app's instance), not totally
take over the user's Excel experience.
Is this possible?
Thanks,
Tony
I've created an Excel application using userforms that is actually pretty
good. I hide the Excel application and using the userforms, you can't really
tell you are in Excel. Ok. Great.
However, if the user has Excel open already, the Excel Application that I
wrote snags and hides everything.
How do you code a workbook in VBA so that when it opens, it opens in its own
instance?
If I then to use application.visible = false, will that just hide the Excel
instance of my application's workbook?
I hope I am conveying what I am trying to do well enough?
I only want to hide the latest instance (my app's instance), not totally
take over the user's Excel experience.
Is this possible?
Thanks,
Tony