Dear All,

I would really appreciate all the available help.

Scenario:
I have 30 worksheets including a Database and a Helper worksheet.

The 28 worksheets are made up of Individual Worksheets of Products:

Sheet 1: XYZ Group
Sheet 2: ABC Group
Sheet 3: TVR Group
Sheet 4: CIA Group
till Sheet 28.

What I wanna do:
a) If cell A1 of ANY Sheet (30 sheets) = 1 or True Then Visible

b) If cell A1 of ANY Sheet (30 sheets) = 2 or False Then Unhide

Result of the Macro:
If 3 items are purchased, then 5 worksheets are displayed:

a) 3 product sheets are displayed; and

b) 2 (database and helper)

I have inserted Alpha Numberic data in cell A1 of Database and Helper
Worksheet, so they are not affected by this.


Thanks for the help.