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" wrote in message
...
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?