+ Reply to Thread
Results 1 to 3 of 3

Hide workbook that runs the Userform only.

  1. #1
    Registered User
    Join Date
    05-08-2016
    Location
    Portugal
    MS-Off Ver
    2013
    Posts
    14

    Hide workbook that runs the Userform only.

    Hello.

    I'm trying to build a user friendly userform for my company.

    I am using this code

    Please Login or Register  to view this content.
    to make it happen.

    the problem is that it hides every single WB that the user may have open and i dont want that to happen.

    Is there a way to hide only the workbook where the userform runs and keep everything else open?

    Thanks in advance

    MODERATOR COMMENT:
    Please review the forum rules. There are not many but are important. I have added code tags for you today. In the future, please do this each time you post code.
    Last edited by alansidman; 05-08-2016 at 07:26 PM.

  2. #2
    Forum Expert
    Join Date
    02-14-2009
    Location
    .
    MS-Off Ver
    ................
    Posts
    2,840

    Re: Hide workbook that runs the Userform only.

    Please Login or Register  to view this content.
    Hides the workbook. Your original take hides the application, a slight difference.

  3. #3
    Registered User
    Join Date
    05-08-2016
    Location
    Portugal
    MS-Off Ver
    2013
    Posts
    14

    Re: Hide workbook that runs the Userform only.

    Thank You.

+ 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. Hide workbook when open userform
    By yangyang88825 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-06-2014, 09:59 PM
  2. Hide/Minimize Excel 2010 workbook when launching userform
    By enderoos in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-18-2014, 02:22 PM
  3. [SOLVED] Best way to hide workbook behind userform
    By VBA FTW in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 01-08-2014, 03:38 PM
  4. [SOLVED] How to Show Userform and Hide Workbook/Worksheet
    By ays_punk in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-29-2013, 01:02 PM
  5. Open userform and hide active workbook only
    By occhibei in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-22-2013, 04:55 PM
  6. Want to Hide a UserForm source book while keeping main XL workbook open...
    By MBlaster in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-03-2012, 05:52 PM
  7. Hide a UserForm on workbook deactivation
    By aca in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-16-2009, 03:22 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