Hide/unhide sheet macro based on cell calculation

I have a spreadsheet that calculates regions in the US. Based on a user
input of city, state I have a lookup that return the region. Each worksheet
ties to the region (ie Region 01) that is returned from the user input. I
created another lookup in case there are multiple returns of the region,
where I have a column that retuns only unique regions. THis is where I need
a macro that will unhide the sheet if the region is named. I have tried
other code from this website, however, it is event enabled and requires a
direct input. Is there something that will work off calculations?

The calculate event is associated with calculations, but isn't specific to a
given cell.

But it seems like the changing of a cell would trigger the calculate, so why
not the change event?

--
Regards,
Tom Ogilvy

"Greg Fisher" <[email protected]> wrote in message
news:[email protected]...
> I have a spreadsheet that calculates regions in the US. Based on a user
> input of city, state I have a lookup that return the region. Each
worksheet
> ties to the region (ie Region 01) that is returned from the user input.
I
> created another lookup in case there are multiple returns of the region,
> where I have a column that retuns only unique regions. THis is where I
need
> a macro that will unhide the sheet if the region is named. I have tried
> other code from this website, however, it is event enabled and requires a
> direct input. Is there something that will work off calculations?

I do not understand why this does not work. I have changed the value of cell
C3 directly, and the macro works. If I have a reference in another sheet to
cell C3 and chage it on the other sheet, it will not work when the
spreadsheet calcs and updates cell C3. For some reason, the macro does not
run.


"Tom Ogilvy" wrote:

> The calculate event is associated with calculations, but isn't specific to a
> given cell.
>
> But it seems like the changing of a cell would trigger the calculate, so why
> not the change event?
>
> --
> Regards,
> Tom Ogilvy
>
> "Greg Fisher" <[email protected]> wrote in message
> news:[email protected]...
> > I have a spreadsheet that calculates regions in the US. Based on a user
> > input of city, state I have a lookup that return the region. Each
> worksheet
> > ties to the region (ie Region 01) that is returned from the user input.
> I
> > created another lookup in case there are multiple returns of the region,
> > where I have a column that retuns only unique regions. THis is where I
> need
> > a macro that will unhide the sheet if the region is named. I have tried
> > other code from this website, however, it is event enabled and requires a
> > direct input. Is there something that will work off calculations?
>
>
>

Change only triggers on a physical edit in this type of situation. You
would need to use the change event where you actually make the change.

--
Regards,
Tom Ogilvy


"Greg Fisher" <[email protected]> wrote in message
news:[email protected]...
> I do not understand why this does not work. I have changed the value of
cell
> C3 directly, and the macro works. If I have a reference in another sheet
to
> cell C3 and chage it on the other sheet, it will not work when the
> spreadsheet calcs and updates cell C3. For some reason, the macro does
not
> run.
>
>
> "Tom Ogilvy" wrote:
>
> > The calculate event is associated with calculations, but isn't specific
to a
> > given cell.
> >
> > But it seems like the changing of a cell would trigger the calculate, so
why
> > not the change event?
> >
> > --
> > Regards,
> > Tom Ogilvy
> >
> > "Greg Fisher" <[email protected]> wrote in message
> > news:[email protected]...
> > > I have a spreadsheet that calculates regions in the US. Based on a
user
> > > input of city, state I have a lookup that return the region. Each
> > worksheet
> > > ties to the region (ie Region 01) that is returned from the user
input.
> > I
> > > created another lookup in case there are multiple returns of the
region,
> > > where I have a column that retuns only unique regions. THis is where
I
> > need
> > > a macro that will unhide the sheet if the region is named. I have
tried
> > > other code from this website, however, it is event enabled and
requires a
> > > direct input. Is there something that will work off calculations?
> >
> >
> >