Dear Dave can you please assist me with YOUR suggestion(hiding/unhiding) with
a macro?
"Dave Peterson" wrote:
How about putting those shapes on Sheet1 and hide them. Then you could have a
macro unhide the one you want.
J.E. McGimpsey shares this in a macro at his site:
http://www.mcgimpsey.com/excel/lookuppics.html
If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
You could also have a macro that copies and pastes, but hiding/unhiding seems
easier (to me).
Christos P wrote:
In cell A1 sheet1 I have a number which lets say represents a code for a
specific shape that i have allready drawn in cell B1 in sheet2.Can you please
tell me what kind of instruction i can give to cell B1,sheet1,so that i can
get that shape from cell B1 sheet2 into B1 sheet1?
--
Dave Peterson