Unhide sheet help

[tswinfor]

Hello,

I am trying to set up a code through a button to unhide certain sheets. I am trying to do this with a small amount of code that has good variable ability.

The set up is a drop down list that will have a number from 1 through 50. The sheets are named Stage 1 through Stage 50. I have it set where you pick the number from the drop down list and it puts the number into the reference cell in the code. You would then click the button and the code would unhide the sheets Stage 1 through Stage "i". (i being the number you picked)

I have my code here and I haven't done VBA in awhile. Please tell me if I can even do this with vba and what is fundamentally wrong with my code.

All help would be greatly appreciated.

Thanks,

AAA

Please Login or Register  to view this content.

[jaslake]

Hi tswinfor

Welcome to the Forum!

You'll need to add code tags to your code (one of the Forum Rules). Since this is your first post I'd do it for you this time...however...I don't have that ability.

Rule 3. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Select your code and click the [#] button at the top of the post window (if you are editing an existing post, press Go Advanced to see the [#] button).

Add the tags...perhaps then we can help.

[tswinfor]

I tried it but It did not work well. I have other sheets in the workbook that I would not like to hide or unhide. I just want the macro locked to that button so that when that button is clicked it will unhide those stage sheets.

[jaslake]

Hi tswinfor

Perhaps something like this

Please Login or Register  to view this content.

[tswinfor]

All,

New update for this. John's code did exactly what I wanted to do but I decided to adjust it. I have it right now where I use 2 buttons. One hides all the sheets and then the other shows only the ones you want. I am putting both John's original code and the one I changed to hide the sheet (notice the only difference is the false) so that you can see both. If someone could help me put this into one sub it would be awesome.

Thanks,

Tyson

Please Login or Register  to view this content.

[yay_excel]

Excel will not allow you to hide all the sheets in a workbook... Your Hide_Sheets code currently hides Stages 1 - 5 only.

[jaslake]

Hi Tyson

The code you posted infers something different than your PM message

I would like it also that for every value greater than the E15 cell that it would hide those sheets.

This code (which is untested) is designed to do the following:
All "Stage#" sheets up to the value of E15 will be made visible.
All "Stage#" sheets from the value of E15 plus 1 to the total sheet count will be hidden.

That's my understanding of the question you posed in the PM. If my understanding in not correct please let me know.

Please Login or Register  to view this content.