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.
Is there any way in an Excel 2013 window to show the ribbon & statusbar but minimise the workbook anymore ?
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.
There's an interesting discussion going on now in an Experts Exchange Group —
Attachments with no extension
. This reminded me of questions that come up here at EE along the lines of, "How can I tell the type of file from its cont…
Most folks would know the basics of how Dropbox works, so that’s not the purpose of this article. Security is what it’s all about, so here I’ll share how I choose to secure my Dropbox Account and the Data it contains.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…