+ Reply to Thread
Results 1 to 6 of 6

Help Hiding sheets with a blank cell

  1. #1
    Registered User
    Join Date
    05-06-2015
    Location
    England
    MS-Off Ver
    2014
    Posts
    71

    Help Hiding sheets with a blank cell

    Hi all,

    Wondering if anyone can tell me where I am going wrong.

    I have a spreadsheet that contains loads of sheets. I want my macro to check a certain cell to see if it has any content, and if it doesn't, hide the sheet.

    When I run this, it only works for the first sheet.

    Thankyou in advance.

    Katy

    Please Login or Register  to view this content.

  2. #2
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,647

    Re: Help Hiding sheets with a blank cell

    Maybe this.....

    Please Login or Register  to view this content.
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  3. #3
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,057

    Re: Help Hiding sheets with a blank cell

    Try changing
    Please Login or Register  to view this content.
    to
    Please Login or Register  to view this content.
    Please help by:

    Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
    Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know

    There are 10 kinds of people in this world... those who understand binary, and those who don't.

  4. #4
    Registered User
    Join Date
    05-06-2015
    Location
    England
    MS-Off Ver
    2014
    Posts
    71

    Re: Help Hiding sheets with a blank cell

    Quote Originally Posted by sktneer View Post
    Maybe this.....

    Please Login or Register  to view this content.
    That works perfectly!

    Thankyou so much!

  5. #5
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,647

    Re: Help Hiding sheets with a blank cell

    You're welcome. Glad to help.

    If that takes care of your original question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.

  6. #6
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Help Hiding sheets with a blank cell

    Does this help?

    Please Login or Register  to view this content.

+ 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. Hiding Sheets based on cell value, only hiding last sheet
    By mattblack2 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-17-2014, 03:21 PM
  2. Mac Excel: Hiding rows if cell blank, when being blank depends on a conditional formula
    By lee_5_5 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 06-06-2013, 11:25 PM
  3. hiding blank rows based on a blank cell
    By Snapon61 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-19-2011, 09:36 PM
  4. Re-Naming Sheets per Cell data & Hiding Sheets
    By dej222 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-26-2009, 10:20 PM
  5. Hiding Blank Rows in All Sheets
    By LoveCandle in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-20-2006, 12:32 AM

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