+ Reply to Thread
Results 1 to 2 of 2

Hide and close single workbook

  1. #1
    Forum Contributor
    Join Date
    07-14-2019
    Location
    Dubai
    MS-Off Ver
    2019
    Posts
    919

    Hide and close single workbook

    Hey

    I have demo vba workbook with userform
    once u open file, application will hide and useform show, once close userform, application will close
    I want some edites, for same work, but only hide and close this workbook, now if I have another workbook runing, it will hide and close with this code

    kindly user dynamic vba file name if there is, rather than "file name" use thisworkbook file name

    Thanks
    Attached Files Attached Files

  2. #2
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,176

    Re: Hide and close single workbook

    Try...

    Please Login or Register  to view this content.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!

+ 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. Copy from first workbook, close open new workbook paste close
    By johncarr1952 in forum Hello..Introduce yourself
    Replies: 2
    Last Post: 08-04-2021, 08:50 AM
  2. Close definitely a workbook and hide the toolbar of excel
    By karlhyun94 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-01-2020, 06:26 PM
  3. hide close,mini,restore button in excel workbook
    By cdtp in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-08-2017, 11:34 AM
  4. [SOLVED] close or hide form when switching workbook
    By k1dr0ck in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-27-2017, 11:46 PM
  5. VBA to hide ribbon (not toolbar) on open workbook, and show on close workboo.
    By lukestkd in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-03-2012, 04:33 AM
  6. Macro to hide sheets / close workbook after inactivity
    By maidenname in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-21-2012, 01:15 AM
  7. Hide, not close, one workbook
    By Ed in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-04-2005, 05:06 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