+ Reply to Thread
Results 1 to 3 of 3

Hide Sheet if Change Worksheets

  1. #1
    Registered User
    Join Date
    06-06-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    51

    Hide Sheet if Change Worksheets

    Hi All,
    Is there any way to hide a sheet if the focus is not on that sheet? I have a sheet labelled "Instructions". It is normally hidden, but there is a button that will un-hide it.
    I would like the sheet to automatically hide when they user clicks on another sheet.
    Thanks in advance.

  2. #2
    Valued Forum Contributor
    Join Date
    11-02-2012
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003, 2007, 2010
    Posts
    564

    Re: Hide Sheet if Change Worksheets

    Paste this in your ThisWorkBook module
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    06-06-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    51

    Re: Hide Sheet if Change Worksheets

    Thanks haripopuri,
    That works perfectly!

+ 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] Hide columns in multiple worksheets - each sheet has its own name
    By Tyso in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-29-2013, 01:53 PM
  2. VBA Password Input Box - Size Change or Hide Sheet When Prompting
    By ryanch69 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-15-2013, 09:29 AM
  3. Macro to hide columns and change formulas in multiple worksheets
    By Catthy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-02-2012, 10:26 PM
  4. Hide or unhide worksheets from cell values in sheet 1
    By glenin in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-07-2011, 06:00 PM
  5. Replies: 3
    Last Post: 05-31-2006, 09:30 AM

Tags for this Thread

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