Hi,

Hiding/unhiding sheets is doable but I don't understand the circumstances in
which you want to do it:

a) If cell A1 of ANY Sheet (30 sheets) = 1 or True Then Visible
How does the 1 get into A1 if the sheet is (presumably) invisible?

b) If cell A1 of ANY Sheet (30 sheets) = 2 or False Then Unhide
Is this not the same as a)?

Mike

" wrote:

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.