VBA to un-hide all sheets between two sheets

Hi all,

I currently use a very simple piece of VBA for switching active sheets using a form button, along with hiding sheets that aren't relevant and un-hiding ones that are. I now have a series of sheets with enough sheets per macro that the way I used to do it is going to be less than ideal. The way I used to do it is this:

Please Login or Register  to view this content.

So simply put:

1) Un-hide my destination sheet
2) Select my destination sheet
3) Hide everything other than my destination sheet

Now what I'm looking for but can't seem to get is a way to instead do:

1) Un-hide all sheets between "DestinationSheet1" and "DestinationSheetX"
2) Select "DestinationSheet1"
3) Hide everything other than the sheets between "DestinationSheet1" and "DestinationSheetX"

The reason is I now need to hide and un-hide larger groups of sheets that are going to be a real pain to maintain if named individually, but will always fall between a static start and end sheet.

Any help would be greatly appreciated! Many thanks,

Q.

Please Login or Register  to view this content.

You sir are a legend, that's perfect, thank you so much!