Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
excel document with shapes on it but the shapes do not print | Excel Worksheet Functions | |||
Conditionally format cell to turn red after lookup match | Excel Discussion (Misc queries) | |||
Naming Auto Shapes and Creating new Shapes | Excel Discussion (Misc queries) | |||
When drawing shapes in excel the shapes keep disappearing | Excel Discussion (Misc queries) | |||
How can i get more 3D shapes for Auto shapes in excel? | Excel Discussion (Misc queries) |