+ Reply to Thread
Results 1 to 5 of 5

Don't hide entire application!

  1. #1
    Registered User
    Join Date
    03-22-2023
    Location
    USA
    MS-Off Ver
    2010
    Posts
    4

    Don't hide entire application!

    I know the following code will hide the entire Excel or Word application:

    Application.visible = false

    But, it doesn't make sense to hide the entire application when I have multiple spreadsheets or documents open.

    Is there a way to only hide one specific MS Word document, but the others stay visible?

    Thanks!

  2. #2
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,737

    Re: Don't hide entire application!

    I am not sure what do you want to do really. But that's should works:

    Please Login or Register  to view this content.
    Happy with my answer * Add Reputation.
    If You are happy with solution, please use Thread tools and mark thread as SOLVED.

  3. #3
    Registered User
    Join Date
    03-22-2023
    Location
    USA
    MS-Off Ver
    2010
    Posts
    4

    Re: Don't hide entire application!

    Yes, that's exactly what I needed. Thanks!

  4. #4
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,737

    Re: Don't hide entire application!

    Happy to help.
    If You are happy with solution, please use Thread tools and mark thread as SOLVED.

  5. #5
    Registered User
    Join Date
    03-22-2023
    Location
    USA
    MS-Off Ver
    2010
    Posts
    4

    Re: Don't hide entire application!

    Oh BTW, instead using the exact filename in your code above, is there a way to specify "this" document or something? There might be situations where users change the filename, and that will break the code.

+ 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 entire row if it contains a 0
    By jtodd in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-13-2018, 10:02 AM
  2. [SOLVED] Open userform and hide excel application
    By z-eighty2 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-31-2014, 11:21 AM
  3. How to hide the Application itself.
    By SteveLou in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-17-2008, 06:58 AM
  4. How to hide entire row if value is zero
    By pbanchetti in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-21-2007, 07:03 PM
  5. Hide application
    By spinkung in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-20-2006, 09:46 AM
  6. Hide an entire tab.
    By ChuckF in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-28-2006, 12:55 PM
  7. Help with application of custom format to entire column
    By Sprinkman in forum Excel General
    Replies: 1
    Last Post: 02-28-2006, 06: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