AutoShape Macro Help
Hi Ken,
Thanks very much for your help. The code is doing exactly as I entended.
My plan was to start off with red faces and change to green if the cell was
filled in. So I changed the the code just slightly.
I appreciate your explanation of the "64" in the code and have added it in
comments to the code so I will remember what "happens" when I refer to it
later.
I've still got to do some protection so that the users don't "mess" with map
and the autoshapes.
I've learned several things, with thanks to you, that probably would still
be a struggle for me several weeks from now. Its great that there are
people out there in the news groups like you that can offer assistance to
folks like me that want to learn.
Thanks again...
Jack
"Ken Johnson" wrote in message
...
Oops!
", and this cell (C7) holds the number of the AutoShape that needs to
be changed."
was meant to be...
", and this cell (C71) holds the number of the AutoShape that needs to
be changed."
Ken Johnson
|