+ Reply to Thread
Results 1 to 3 of 3

VBA code to hide sheets based on user input

  1. #1
    Forum Contributor
    Join Date
    02-13-2016
    Location
    MUMBAI
    MS-Off Ver
    Microsoft 365
    Posts
    180

    VBA code to hide sheets based on user input

    hii..

    PFA the Demo file..

    INDEX sheet contains the name of all the sheets in the workbook.

    I want when user enters 2,3,14 in InputBox so it should hide "Interest Calc", "Diff Liability" & "3B Multi Month Report" sheets based on Table of Contents & not based on the actual order of sheets.

    VBA Code??

    Thank You..
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    11-04-2014
    Location
    Portugal
    MS-Off Ver
    XL2013/XL365
    Posts
    88

    Re: VBA code to hide sheets based on user input

    Look if this resolve your problem
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    02-13-2016
    Location
    MUMBAI
    MS-Off Ver
    Microsoft 365
    Posts
    180

    Re: VBA code to hide sheets based on user input

    Solved. Thank you very much.

+ 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. Hide All Rows and Display only one row based on User input
    By neetag in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 11-23-2020, 08:44 PM
  2. Hide Some Sheets based on the user
    By subodhsapkota in forum Excel General
    Replies: 1
    Last Post: 01-29-2019, 10:53 PM
  3. Replies: 15
    Last Post: 07-11-2017, 10:55 AM
  4. Help with code to determine which sheets to import using user input
    By techkels in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-27-2014, 03:16 PM
  5. [SOLVED]Hide Rows and Columns Based on User Input
    By thesteve in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-31-2013, 01:32 PM
  6. [SOLVED] Refreshing/Recalculating Sheets based on user input or switching between sheets
    By SonOfOdin in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-24-2012, 09:48 PM
  7. Hide sheets based on cell value input
    By EdMac in forum Excel General
    Replies: 10
    Last Post: 11-17-2006, 06:01 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