ActiveSheet.Shapes("Chart 2").Visible = False

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"omega" wrote in message
...

Rick,

Its okay. The edited version of Dons code works well in my worksheet
because it has a €œfreeze pane€� at AE6. My goal is to display a group of
charts contained in the right side of the pane, column AE, when a cell in
column E (left side of the pane) is selected. The chart serves as a visual
guide to the user depending on the cell/column selected. Without the
€œfreeze
pane€�, the code will not achieve anything. Furthermore, when the user
selects
a cell in column F, at the left side of the pane, the code automatically
scrolls the right side of the pane and displays column AF where another
group
of charts is present, then goes back to the previously selected cell at
the
left side of the €œfreeze pane€�€¦. And so on€¦

This primitive way of displaying a guide chart for the user works fine
with
me as of the meantime, until I will learn a way to pop-up a €œgroup of
charts€�
when a cell in a column is selected.

By the way, is this possible? €¦popping up a group of charts when a cell is
selected?

Thank you,

Omega

===============================

"Rick Rothstein" wrote:

What is it you think these 5 lines of code (actually, I only see 4 lines
of
code) you posted are doing??? All I see them doing is re-selecting the
cell
you just selected.

--
Rick (MVP - Excel)