|
-
Aug 26th, 2009, 10:37 PM
#1
Thread Starter
Hyperactive Member
[RESOLVED] Hiding sheets based on their Tab name
I have a workbook with a LOT of sheets, and they are named by SITECODE-NENUMBER
"ATGXGA-000x" 1 though 24
"ATFIGA-000x" 1 through 12
etc.etc
"there are lots more"
Is there a way to hit a botton Labeled ATGXGA and hide all the others? I would want it to just look at the SITECODE
ohh and I don't mean to have to list them all and put visible = true
I do that now, and have to go in and edit the Macro when I add another node.
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|