Excel 2016 - Hidden application unhides if another workbook cosesUnhiding 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

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.










share|improve this question




























    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.










    share|improve this question
























      0












      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.










      share|improve this question














      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













      share|improve this question











      share|improve this question




      share|improve this question










      asked Mar 25 at 9:40









      Marius KatinasMarius Katinas

      3421 gold badge4 silver badges12 bronze badges




      3421 gold badge4 silver badges12 bronze badges






















          0






          active

          oldest

          votes














          Your Answer






          StackExchange.ifUsing("editor", function ()
          StackExchange.using("externalEditor", function ()
          StackExchange.using("snippets", function ()
          StackExchange.snippets.init();
          );
          );
          , "code-snippets");

          StackExchange.ready(function()
          var channelOptions =
          tags: "".split(" "),
          id: "1"
          ;
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function()
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled)
          StackExchange.using("snippets", function()
          createEditor();
          );

          else
          createEditor();

          );

          function createEditor()
          StackExchange.prepareEditor(
          heartbeatType: 'answer',
          autoActivateHeartbeat: false,
          convertImagesToLinks: true,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: 10,
          bindNavPrevention: true,
          postfix: "",
          imageUploader:
          brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
          contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
          allowUrls: true
          ,
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          );



          );













          draft saved

          draft discarded


















          StackExchange.ready(
          function ()
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55334906%2fexcel-2016-hidden-application-unhides-if-another-workbook-coses%23new-answer', 'question_page');

          );

          Post as a guest















          Required, but never shown

























          0






          active

          oldest

          votes








          0






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes















          draft saved

          draft discarded
















































          Thanks for contributing an answer to Stack Overflow!


          • Please be sure to answer the question. Provide details and share your research!

          But avoid


          • Asking for help, clarification, or responding to other answers.

          • Making statements based on opinion; back them up with references or personal experience.

          To learn more, see our tips on writing great answers.




          draft saved


          draft discarded














          StackExchange.ready(
          function ()
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55334906%2fexcel-2016-hidden-application-unhides-if-another-workbook-coses%23new-answer', 'question_page');

          );

          Post as a guest















          Required, but never shown





















































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown

































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown







          Popular posts from this blog

          Kamusi Yaliyomo Aina za kamusi | Muundo wa kamusi | Faida za kamusi | Dhima ya picha katika kamusi | Marejeo | Tazama pia | Viungo vya nje | UrambazajiKuhusu kamusiGo-SwahiliWiki-KamusiKamusi ya Kiswahili na Kiingerezakuihariri na kuongeza habari

          SQL error code 1064 with creating Laravel foreign keysForeign key constraints: When to use ON UPDATE and ON DELETEDropping column with foreign key Laravel error: General error: 1025 Error on renameLaravel SQL Can't create tableLaravel Migration foreign key errorLaravel php artisan migrate:refresh giving a syntax errorSQLSTATE[42S01]: Base table or view already exists or Base table or view already exists: 1050 Tableerror in migrating laravel file to xampp serverSyntax error or access violation: 1064:syntax to use near 'unsigned not null, modelName varchar(191) not null, title varchar(191) not nLaravel cannot create new table field in mysqlLaravel 5.7:Last migration creates table but is not registered in the migration table

          은진 송씨 목차 역사 본관 분파 인물 조선 왕실과의 인척 관계 집성촌 항렬자 인구 같이 보기 각주 둘러보기 메뉴은진 송씨세종실록 149권, 지리지 충청도 공주목 은진현