How to turn on Shapes conditionally?
Hi Ken,
I have emailed you a sample of my work with detail explanation. Looking
forward to your input.
Thanks again,
DORI
"Ken Johnson" wrote:
Hi DORI,
Sorry, but there are too many unknowns for me to be able to answer your
question.
If you email me a copy of the workbook I would stand a better chance of
solving the problem.
I'm curious to see exactly what the workbook does.
I could be wrong, but from my reading of your last reply it appears to
me as though you are trying to control the visibility of both sets of
freeforms (or groups or whatevers) from the same cell, namely H10.
The way the code is set up, the value in H10 controls the visibility of
the first set of shapes, the ones with name ending in 01, while the
second set of shapes, with name ending in 02, have to have their
visibility controlled by a value in a different cell (I made it A1 and
told you how to change it to any other cell; but not H10, which is
reserved for controlling set one's shape's visibility).
Please correct me if I have got it wrong.
If your are willing and able to email me a copy could you include a
brief description of what the user is meant to do and how the sheet is
supposed to respond.
Also, if I have I copy then I can have a close look at Table1, Table2
and the Data Validation List.
Ken Johnson
|