Results 1 to 7 of 7

Need automatic macro that makes 4 sheets disappear if a sheet outside of those 4 is select

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-03-2005
    Posts
    269

    Need automatic macro that makes 4 sheets disappear if a sheet outside of those 4 is select

    Hi all..

    I have done this before with one sheet, where I use the deactivate command in the code for that sheet, if that sheet is deselected then it disappears...

    Private Sub Worksheet_Deactivate()
    
     ThisWorkbook.Sheets("Instructions").Visible = False
    End Sub
    What I want to know know, is if I select a sheet other than sheet1, sheet2, sheet3 and sheet4, than those 4 all become hidden.

    Thanks,
    Last edited by caliskier; 05-18-2016 at 12:23 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. A maco makes all my Vlookups and formulas disappear!!!!
    By marvinabou7890 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-11-2016, 08:20 PM
  2. Workbook.Save makes Userform Disappear
    By Antenne88 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-26-2015, 06:30 PM
  3. Group - Makes my rows disappear
    By spookiepower in forum Excel General
    Replies: 3
    Last Post: 07-30-2013, 05:06 PM
  4. MouseOver cell that makes apear and disappear an image
    By blakito in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-20-2012, 12:57 PM
  5. MouseOver cell that makes apear and disappear an image
    By first_mo_za in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-20-2012, 03:37 AM
  6. Why does #DIV/O appear? Retyping the figures makes it disappear!!
    By HAYLEYFARMINER in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-28-2008, 09:20 AM
  7. [SOLVED] Insert-Subtotals makes Column Outlines disappear
    By gpie in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-22-2005, 12:10 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