Results 1 to 8 of 8

Macro to hide worksheet

Threaded View

maidenname Macro to hide worksheet 09-20-2013, 03:28 PM
HaHoBe Re: Macro to hide worksheet 09-20-2013, 03:56 PM
maidenname Re: Macro to hide worksheet 09-20-2013, 04:32 PM
HaHoBe Re: Macro to hide worksheet 09-20-2013, 04:46 PM
maidenname Re: Macro to hide worksheet 09-21-2013, 09:41 AM
HaHoBe Re: Macro to hide worksheet 09-21-2013, 10:18 AM
maidenname Re: Macro to hide worksheet 09-21-2013, 12:34 PM
HaHoBe Re: Macro to hide worksheet 09-21-2013, 12:47 PM
  1. #1
    Registered User
    Join Date
    05-20-2012
    Location
    Bournemouth
    MS-Off Ver
    Excel 2010
    Posts
    6

    Macro to hide worksheet

    HI EVERYONE I HAVE A MACRO TO DISPLAY WORKSHEETS BASED ON CELL VALUE IN ANOTHER WORKSHEET PART DISPLAYED BELOW, I NEED AN ADDITION TO THAT MACRO TO HIDE ANY OF THOSE VISIBLE WORKSHEETS BASED ON CELL VALUE WITHIN THOSE INDIVIDUAL WORKSHEET i.e. IF A1 IN S7A = "BYE" THEN HIDE THAT WORKSHEET

    Sheets("Teams").Visible = True
    Sheets("Teams").Select
    Let x = 3
    Let y = 2
    Cells(x, y).Select
    If Cells(x, y) = "1" Then check = True Else check = False
    If check = False Then GoTo m:
    Sheets("S7A").Visible = True
    Sheets("S8A").Visible = True
    Sheets("S9A").Visible = True
    Sheets("Teams").Select
    Range("B3").Select
    Sheets("Teams").Visible = False
    Any help would be appreciated
    Last edited by jeffreybrown; 09-21-2013 at 10:25 AM. Reason: As per Forum Rule #3, please use code tags…Thanks.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] hide a worksheet so that a macro can still find it
    By frendabrenda1 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-06-2005, 10:05 AM
  2. [SOLVED] hide a worksheet so that a macro can still find it
    By Ron de Bruin in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-06-2005, 07:05 AM
  3. hide a worksheet so that a macro can still find it
    By frendabrenda1 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 PM
  4. hide a worksheet so that a macro can still find it
    By frendabrenda1 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 PM
  5. Macro to hide columns in worksheet
    By molavi111 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-23-2005, 12:56 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