Styjun

Should I prioritize my 401(k) over my student loans?

Why is the high-pass filter result in a discrete wavelet transform (DWT) downsampled?

Is adding a new player (or players) a DM decision, or a group decision?

Can White Castle?

Find the probability that the 8th woman to appear is in 17th position.

Does this Wild Magic result affect the sorcerer or just other creatures?

Is it possible writing coservation of relativistic energy in this naive way?

What is the mechanical difference between the Spectator's Create Food and Water action and the Banshee's Undead Nature Trait?

Why is C++ initial allocation so much larger than C's?

The Target Principal Name Is Incorrect. Cannot Generate SSPI Context (SQL or AD Issue)?

Computing a trigonometric integral

Is there a maximum distance from a planet that a moon can orbit?

“D’entre eux” to mean “of them”

Hot coffee brewing solutions for deep woods camping

Inverse-quotes-quine

How to split an equation in two lines?

Would it be a copyright violation if I made a character’s full name refer to a song?

Is there a way to split the metadata to custom folders?

How do I set an alias to a terminal line?

Cascading Repair Costs following Blown Head Gasket on a 2004 Subaru Outback

STM Microcontroller burns every time

Swapping rooks in a 4x4 board

How do I turn off a repeating trade?

Can the negators "jamais, rien, personne, plus, ni, aucun" be used in a single sentence?

Excel 2016 - Hidden application unhides if another workbook coses

Unhiding very hidden sheet Excel VBAExcel 2013 - issue when closing multiple workbooks if one workbook is hiddenWhen any workbook is added or closed to the active workbook the Visibilty status of the application is effectedHidden Excel Application gets visible when user opens new workbooksUnhiding Excel 2013 Windows when all Windows are hidden with VBAHide Excel Application with specific conditionsTrying to copy data from a closed workbook to a current workbookHow do you open a vbmodeless userform through a hyperlink?Excel VBA hyperlink to unhide hidden and very hidden sheetsSaveChanges Prompt Box in Excel VBA

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

As of recently we upgraded Excel to 2016. Issue was not present in earlier versions.

I am working with a hidden Excel application (show's only userform) and in that application I'm using a separate workbook to load data. Once I close data loader workbook, my main application becomes visible. Code to recreate this behavior:

Sub Test()
 Dim currentWorkbook As Workbook
 Dim newWorkbook As Workbook

 Set currentWorkbook = ThisWorkbook
 currentWorkbook.Application.Visible = False

 Set newWorkbook = currentWorkbook.Application.Workbooks.Add 'Same with Workbooks.Open
 newWorkbook.Close savechanges:=False
End Sub

After this code is run, current workbook window becomes visible. After I make whole application visible using Immediate window, a new blank (gray) Excel screen appears. While I was testing my code, I ran it around 20 times and when forcefully unhiding whole application, that many blank Excel windows were shown.

I'm worried, that if I just run Application.Hide every time workbook is closed, explorer is going to clog up from all blank Excel windows and may cause performance issues.

Question: how can I avoid leftover Excel blank windows when closing workbooks within same application and keep my original workbook hidden?

Thank you.

excel vba

share|improve this question

asked Mar 25 at 9:40

Marius KatinasMarius Katinas

34211 gold badge44 silver badges1212 bronze badges

add a comment | 

0

As of recently we upgraded Excel to 2016. Issue was not present in earlier versions.

I am working with a hidden Excel application (show's only userform) and in that application I'm using a separate workbook to load data. Once I close data loader workbook, my main application becomes visible. Code to recreate this behavior:

Sub Test()
 Dim currentWorkbook As Workbook
 Dim newWorkbook As Workbook

 Set currentWorkbook = ThisWorkbook
 currentWorkbook.Application.Visible = False

 Set newWorkbook = currentWorkbook.Application.Workbooks.Add 'Same with Workbooks.Open
 newWorkbook.Close savechanges:=False
End Sub

After this code is run, current workbook window becomes visible. After I make whole application visible using Immediate window, a new blank (gray) Excel screen appears. While I was testing my code, I ran it around 20 times and when forcefully unhiding whole application, that many blank Excel windows were shown.

I'm worried, that if I just run Application.Hide every time workbook is closed, explorer is going to clog up from all blank Excel windows and may cause performance issues.

Question: how can I avoid leftover Excel blank windows when closing workbooks within same application and keep my original workbook hidden?

Thank you.

excel vba

share|improve this question

asked Mar 25 at 9:40

Marius KatinasMarius Katinas

34211 gold badge44 silver badges1212 bronze badges

add a comment | 

As of recently we upgraded Excel to 2016. Issue was not present in earlier versions.

I am working with a hidden Excel application (show's only userform) and in that application I'm using a separate workbook to load data. Once I close data loader workbook, my main application becomes visible. Code to recreate this behavior:

Sub Test()
 Dim currentWorkbook As Workbook
 Dim newWorkbook As Workbook

 Set currentWorkbook = ThisWorkbook
 currentWorkbook.Application.Visible = False

 Set newWorkbook = currentWorkbook.Application.Workbooks.Add 'Same with Workbooks.Open
 newWorkbook.Close savechanges:=False
End Sub

After this code is run, current workbook window becomes visible. After I make whole application visible using Immediate window, a new blank (gray) Excel screen appears. While I was testing my code, I ran it around 20 times and when forcefully unhiding whole application, that many blank Excel windows were shown.

I'm worried, that if I just run Application.Hide every time workbook is closed, explorer is going to clog up from all blank Excel windows and may cause performance issues.

Question: how can I avoid leftover Excel blank windows when closing workbooks within same application and keep my original workbook hidden?

Thank you.

excel vba

share|improve this question

asked Mar 25 at 9:40

Marius KatinasMarius Katinas

34211 gold badge44 silver badges1212 bronze badges

Sub Test()
 Dim currentWorkbook As Workbook
 Dim newWorkbook As Workbook

 Set currentWorkbook = ThisWorkbook
 currentWorkbook.Application.Visible = False

 Set newWorkbook = currentWorkbook.Application.Workbooks.Add 'Same with Workbooks.Open
 newWorkbook.Close savechanges:=False
End Sub

share|improve this question

asked Mar 25 at 9:40

Marius KatinasMarius Katinas

34211 gold badge44 silver badges1212 bronze badges

share|improve this question

asked Mar 25 at 9:40

Marius KatinasMarius Katinas

34211 gold badge44 silver badges1212 bronze badges

asked Mar 25 at 9:40

Marius KatinasMarius Katinas

34211 gold badge44 silver badges1212 bronze badges

asked Mar 25 at 9:40

Marius KatinasMarius Katinas

34211 gold badge44 silver badges1212 bronze badges