+ Reply to Thread
Results 1 to 2 of 2

Using VBA code to hide/show certain sheets in a workbook

  1. #1
    Registered User
    Join Date
    10-10-2014
    Location
    Lexington, KY
    MS-Off Ver
    2010
    Posts
    1

    Using VBA code to hide/show certain sheets in a workbook

    Hey everybody,

    I have been learning more about excel this summer and I do not know very much about writing the code. However, I have two sets of codes (If, then's) that work individually, but I need them to work at the same time. I have two cells with domain names, and based off of the answers entered in BOTH of these cells, I need certain sheets to show and other to disappear.

    I have tried to do some self teaching about nested statements and select cases, but I just don't understand code well enough to solve this! Can anyone lend me a hand pretty please??

    Thank you!
    SK

  2. #2
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Using VBA code to hide/show certain sheets in a workbook

    Welcome to the forum

    Be more specific with your question. What, exactly, are you trying to achieve?

    Post your existing code. Attach a workbook, if it would help.

    You know what your issue is - all we have to work with is what you post.
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

+ 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. Checkbox to show / hide workbook sheets
    By ed_b1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-09-2013, 07:17 AM
  2. Use checkbox to show/hide sheets?
    By Zheno in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-03-2010, 02:49 PM
  3. Problem with macro - show/hide sheets
    By uncleslinky in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-04-2009, 04:13 AM
  4. Hide Workbook, run code then show.
    By DelMonte in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-21-2009, 07:37 AM
  5. hide/show multiple sheets by macro ?
    By Simon-ch in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 10-30-2008, 05:25 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