VBA to hide worksheets based on cell value

[tantcu]

Hello,

I'm looking for a vba that can look up any visible/invicible worksheets then decided to hide or unhide the worksheets based on cell G1 from sheets "Report Builder". For example, if cell G1 from sheets(Report Builder) says Discrete Customers. It will hide any other sheets only display sheets "Report Builder" and Sheets " Discrete Customers".or if it say Product family it will hide all other sheets except sheets report builder and product family sheet.

Thank you for your help.

[rscsmith]

Hi tantcu

I think this does the job:

Please Login or Register  to view this content.

Best regards, Rob.

[tantcu]

Thank you. It worked great!