+ Reply to Thread
Results 1 to 4 of 4

Close ms vba window - code

  1. #1
    Valued Forum Contributor bulina2k's Avatar
    Join Date
    11-20-2012
    Location
    Urziceni, Ialomita, Romania
    MS-Off Ver
    2019 and 365
    Posts
    862

    Close ms vba window - code

    Hi again!

    Because I work with
    Please Login or Register  to view this content.
    my VBA Window stays opened after the code is executed. active.jpg
    Is there a way to close that window also by code?
    Thank you!
    .. and don't forget to have fun!
    Bogdan.

    mark SOLVED and Add Reputation if my answer pleases you

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Close ms vba window - code

    What are you doing with that code?
    If posting code please use code tags, see here.

  3. #3
    Forum Guru Izandol's Avatar
    Join Date
    03-29-2012
    Location
    *
    MS-Off Ver
    Excel 20(03|10|13)
    Posts
    2,581

    Re: Close ms vba window - code

    You may try:
    Please Login or Register  to view this content.
    • Please remember to mark threads Solved with Thread Tools link at top of page.
    • Please use code tags when posting code: [code]Place your code here[/code]
    • Please read Forum Rules

  4. #4
    Valued Forum Contributor bulina2k's Avatar
    Join Date
    11-20-2012
    Location
    Urziceni, Ialomita, Romania
    MS-Off Ver
    2019 and 365
    Posts
    862

    Re: Close ms vba window - code

    Quote Originally Posted by Norie View Post
    What are you doing with that code?
    I'm writing code on Workbook_Open event for a new file I create with Worksheet("bla").Copy

  5. #5
    Valued Forum Contributor bulina2k's Avatar
    Join Date
    11-20-2012
    Location
    Urziceni, Ialomita, Romania
    MS-Off Ver
    2019 and 365
    Posts
    862

    Re: Close ms vba window - code

    Quote Originally Posted by Izandol View Post
    You may try:
    Please Login or Register  to view this content.
    That worked on a sample offline file! Thank you! Tomorrow i'll test it on-line.

    Later edit: Works like a charm! Thank you guys!
    Last edited by bulina2k; 02-13-2014 at 07:18 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] VBA code creating E-mail, display it and close window after - Doesn't work
    By Hemandk84 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-13-2013, 09:43 AM
  2. [SOLVED] Close excel window
    By cober123 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-15-2013, 03:10 PM
  3. Close New Window
    By Yvettemv in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 05-04-2012, 10:36 AM
  4. How do you close a window with a hidden UserForm in it?
    By skysurfer in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-16-2010, 07:58 PM
  5. [SOLVED] Close Excel mac help window
    By BillyC in Ross in forum Excel General
    Replies: 0
    Last Post: 08-05-2006, 02:30 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1