Hide/Unhide specific Worksheet groups

[CLEE7093]

Please refer to the attached workbook. It is dummy information so there is nothing protected.

As you can see, there is a large number of worksheets. This is intended to be used as an audit package where the standard is a single year audit. It may be necessary to expand up to a maximum of five years. The original year of audit is not labeled any certain way. The expansion years are labeled X1…, X2…, X3…, and X4…

I would like to have only the base year or original year displayed when the workbook is initiated. Based on responses on the worksheet ADJUSTMENT SUMMARY, I would like to unhide each year as necessary. In other words, when I finish the base year and discover that I need to expand by one year, I would like the sheets beginning with X1 to be unhidden. If I need to go to another year, then X2, and so on. Toggle buttons are not out of the question to hide/unhide.

I am a novice when it comes to programming and have already tried cutting & pasting code from this forum and around the internet. Unfortunately I don’t know enough about coding to customize it. My worksheets are not in proper number sequence so names must be used.

THANK YOU in advance!!!

[CLEE7093]

Bump no response

[CLEE7093]

I was able to solve this myself.