Workbook doesn't open (Lost Focus)

Hello guys

I noticed something very strange. When you have an installed AddIn that does nothing more than showing a userform on opening, then the following happens when you start Excel by double clicking on any excel file:

1) Double Click on any Excel file
2) Excel Application will start and load the AddIn
3) The AddIn will show the Userform
4) I cancel the userform by clocking on the ok button => Unload Me
5) The original excel file that you double clicked will NOT open anymore

Can anybody tell me why this happens and how I can prevent it - of course I need the userform during opening and I don't want to use a timer controled start of the userform...

Regards
Marc

Why do you need a userform when the add-in opens?

I can't say I'm particularly curious - I suspect it's a DDE timeout - but the workarounds are quite simple. However, I loathe nag screens so it's one of the few things I won't assist with (like flashing cells).
I can't replicate your other issue - can you provide sample code to show the exact sequence of events?

Originally Posted by romperstomper

I can't say I'm particularly curious - I suspect it's a DDE timeout - but the workarounds are quite simple. However, I loathe nag screens so it's one of the few things I won't assist with (like flashing cells).
I can't replicate your other issue - can you provide sample code to show the exact sequence of events?

I have a solution, I just look for the reason. My solution is to use a modeless and/or timer controled form.

Other issue

Please install the attached AddIn and look that you have any workbook in the background when you start the Macro in the AddIn.

Please Login or Register  to view this content.

Try using Activeworkbook.Followhyperlink instead.

It would appear to be a bug since an add-in should not ever be the active workbook.

Originally Posted by romperstomper

It would appear to be a bug since an add-in should not ever be the active workbook.

Yes, maybe. It would not be the first bug that they have and never fix... At least they collect all their bugs in a nice bug list...

However, there is a solution that I found although it still doesn't explain the problem:

If you use first the Workbooks collection to activate any other workbook, then the problem is fixed...

Please Login or Register  to view this content.

Thanks and Regards
Marc

I thought you weren't interested in solutions?

In future, when posting code (however little) please use code tags as per the forum rules. I have added them for you twice now.

Also, don't forget to mark this solved, please.

Originally Posted by romperstomper

I thought you weren't interested in solutions?

In future, when posting code (however little) please use code tags as per the forum rules. I have added them for you twice now.

Also, don't forget to mark this solved, please.

I'm sorry. I must admit I didn't read all the rules... It's a lot of text you know...
I didn't notice, that you fixed my postings. Of course I will use the code tags in future...

I'm interested in fixing the problem and your way is better than mine, although I always prefer also to understand why something doesn't work, but I can live with the fact that it is - as often - one of many many Excel bugs...

Regards
Marc

[SOLVED]