Hide/unhide cells within range

[lucassdm7]

Hi all,

Thanks to this forum I managed to name sheets within a range (between the sheets "Start" and "End") yesterday.

Now I'm trying to hide/unhide the same sheet range with a button, using below code, but it doesn't work.

Please Login or Register  to view this content.

Any idea how to correct this?

In a dream world it would be activated by a button where you simply click either choice, something like this [ O Hide O Unhide ]

Many thanks in advance.

[Fluff13]

How about

Please Login or Register  to view this content.

[lucassdm7]

Once again you are the man, many thanks!

A follow up question though. When I insert an Option Button, I only get one option box and when click it hides the sheets (so far so good). Clicking it again obviously does not unhide them. How would I assign a dual box option button showing hide/unhide?

Thanks a lot.

[Fluff13]

If you assign the macro to a Forms control option button, it will hide/unhide everytime you click the button.
Another option would be to use a Shape

[lucassdm7]

I played around with it and a single option button actually reverse current status. Ie, if all sheets are shown and I click the button all sheets become hidden. If all sheets are hidden and I click the button all sheets become unhidden. But if one or more sheets are hidden or not hidden as compared to the rest of the sheets, by clicking the button they just reverse, ie those that were hidden flips to unhidden and vice versa.

Would it be possible to change the code to only hide sheets when clicking the button? And then another one where it only unhides any unhiddden sheets?

Many thanks!

[Fluff13]

To unhide sheets use

Please Login or Register  to view this content.

and change xlSheetVisible to xlSheetHidden to hide them

[lucassdm7]

That worked, you're a life saver!

Thanks for all your help.

[Fluff13]

You're welcome & thanks for the feedback