Thanks very much for your response, I could also use something like this,
but I cannot seem to get it to work. I keep getting an error on the first
line.........and it comes up RED when viewing the code...........

if sheets("sheets1")hidden = true then

Vaya con Dios,
Chuck, CABGx3



wrote in message
...
hi,
maybe not clickin on the sheet but you could add a custom
icon and assign a macro to it.
Sub machidesheets()
if sheets("sheets1")hidden = true then
Sheets("sheet1").unhide
Sheets("sheet2").hide
else
Sheets("sheet1").hide
Sheets("sheet2").unhide
end if
end sub
this code would unhide sheet1 and hide sheet2 if sheet1
was hidden or unhide sheet 2 and hide sheet1 if sheet1 was
not hidden.
you would have to add a line for each sheet you want to
hide or unhide.
regards

-----Original Message-----
Hi All.....

I create various maps, or diagrams in Excel. There are
two major types,
"ORIGINAL", and "FUTURE". Each type has several support
sheets to go with
it. I was wondering if it would be possible to create a
macro that would
automatically expose to view, only those sheets (sheets C-
H)associated with
the ORIGINAL sheet when I click on that one, and then
hide those and expose
only those (sheets I-N) associated with the FUTURE sheet
when I click on that
one, and back and forth.

TIA for any ideas.....

Vaya con DIos,
Chuck, CABGx3


.