Solved

Excel 2013 VBA: Change to the MDI interface of old

Posted on 2016-08-24
4
190 Views
Last Modified: 2016-09-27
Background

In Excel 2010 and earlier versions the Excel app was an MDI (Multiple Document Interface) and so hosted multiple workbook windows in the one application window. In Excel 2013 this changed and each workbook appears to open in a new session of Excel - even if they 'share' functionality like custom Ribbons.

Question

Is there any way in an Excel 2013 window to show the ribbon & statusbar but minimise the workbook anymore ?

Explanation

The reason I ask is that I have a long standing complex Excel addin that basically cycles through multiple workbooks and while doing so minimises all workbook windows and shows a dialog (userform) that shows the processing's progress.

Now under Excel 2010 (and previous) this worked perfectly: while the addin was processing all windows were minimised and the progress bar was shown. Under 2013 however it is messy -  in order to show the progress bar it re-shows the workbook underneath - there seems no way to separate the two.

When I show my progress form I could use 'Application.visible = False' but I would rather not do this as it leaves the user with no ribbon , no status bar, no application icon in the Windows taskbar and therefore no clear idea of what program is running.


Any suggestions or advice would be much appreciated.
0
Comment
Question by:AL_XResearch
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 18

Assisted Solution

by:xtermie
xtermie earned 500 total points (awarded by participants)
ID: 41768727
Have you tried
Excel 2010\2013:
a.     Open Excel.
b.    Select File | Options.  The Excel Options window will be displayed
c.     Select Advanced.  The Advanced options for working with Excel page displays.
d.    Under the Display section, remove the checkmark from the checkmark next to Show all windows in the Taskbar.  
e.     Click the OK button.
0
 
LVL 3

Author Comment

by:AL_XResearch
ID: 41768798
Hi xtermie, thanks for the response.

That option only exists in 2010 ! That is not exactly what I want (unless it can be automated in VBA)  but it is a start but sadly was removed from 2013 as shown in the snapshot and link below:

Excel 2013 - Advanced Options - Display
Microsoft documentation of Excel 2013 changes
0
 
LVL 18

Accepted Solution

by:
xtermie earned 500 total points (awarded by participants)
ID: 41789199
0
 
LVL 18

Expert Comment

by:xtermie
ID: 41817509
valid comments and recommendations provided to author
0

Featured Post

WordPress Tutorial 4: Recommended Plugins

Now that you have WordPress installed, understand the interface, and know how to install new parts, let’s take a look at our recommended plugins.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article helps those who get the 0xc004d307 error when trying to rearm (reset the license) Office 2013 in a Virtual Desktop Infrastructure (VDI) and/or those trying to prep the master image for Microsoft Key Management (KMS) activation. (i.e.- C…
An introduction to the wonderful sport of Scam Baiting.  Learn how to help fight scammers by beating them at their own game. This great pass time helps the world, while providing an endless source of entertainment. Enjoy!
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…

630 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question