+ Reply to Thread
Results 1 to 2 of 2

Unhide worksheets based on input value

  1. #1
    Forum Contributor
    Join Date
    12-13-2007
    Posts
    138

    Unhide worksheets based on input value

    I am wondering if it is possible to have three macros that do the following:

    1. Unhide 'x' number of worksheets based on an input cell, i.e. if a person puts 3 in the input cell, 3 worksheets with a specific sheet name will become unhidden.

    Example

    1. In my attached workbook on the 'baseline' sheet in cells C2:C4 are the input cells for number if worksheets to be unhidden. If '4' is input into cell C2, then 4 'H workssheets' will become unhidden and so on.

    I know Im asking a lot, but any help with this would be greatly appreciated as I know there is a fair bit of effort invovled in writing macros. Thanks in advance.
    Last edited by FM1; 02-17-2010 at 09:29 AM.

  2. #2
    Forum Contributor
    Join Date
    12-13-2007
    Posts
    138

    Re: Unhide worksheets based on input value

    Would appreciate it if someone could advise if this is even possible. If not, Ill have to abandon the idea.

    Thanks in advance.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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