Excel 2013 SDI, modal User Forms and multi-workbook.

Hi Experts,

I'm having a problem with my VBA app an all Office 2013 computers. When they run some procedures, they get strange errors no one gets in pre-2013 versions. This is the most urgent I'm dealing with now:

Workbook1 is open. Procedure_A calls userform_A which creates a Workbook2 filling it with calculations from Workbook1. When both are finished, Workbook2 is active but its ribbon is frozen, blank. If I switch back to Workbook1, its ribbon is visible and functional. The only way to close workbook2 is by right-clicking on the task bar. This does not happen on Excel 2010.

I know this is happening because SDI doesn't work well with modal user forms, but it would be a pain in the neck to rewrite several parts of my code just to go modeless, not to mention finding ways to prevent users from ruining everything by clicking on the background while the user form is still active.

Is there any work around this?

Thanks,
Pablo.
JohnPabloAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

[ fanpages ]IT Services ConsultantCommented:
If you change your code (in "userform_A") to close the newly created "Workbook2" after "filling it with calculations from Workbook1", then re-open "Workbook2" during the Form_Unload event of "userform_A" (if the contents are required to be seen immediately), is the issue with the Ribbon still present?

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
JohnPabloAuthor Commented:
Fanpages:

It makes a lot of sense. One quite obvious way I found to fix it was moving the code that added the new workbook out of the user form. Since I have a number of procedures that work this way, moving the code or going modeless is not always an easy fix; but closing the new file, closing the user form, and then reopening the file seems like a viable option.

I'll let you know how it goes.
[ fanpages ]IT Services ConsultantCommented:
Are you still working on this, Pablo?
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

JohnPabloAuthor Commented:
I've requested that this question be deleted for the following reason:

It didn't raise enough interest.
[ fanpages ]IT Services ConsultantCommented:
---
Delete Request Pending

JohnPablo requested that this question be deleted for the following reason:

It didn't raise enough interest.

To cancel this request and generate a request for Moderator review, state your reason for objecting in the standard comment box and click the 'Object' button. This question will be closed on 7/22/2015 if there are no objections.
---

Objection: The question asker is opting to delete a thread without providing feedback on an ongoing solution.
Martin LissOlder than dirtCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.