View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Webtechie Webtechie is offline
external usenet poster
 
Posts: 84
Default Start my Application in its OWN instance?

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