LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #12   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35
Default 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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
excel document with shapes on it but the shapes do not print [email protected] Excel Worksheet Functions 2 October 22nd 09 06:17 PM
Conditionally format cell to turn red after lookup match Dan H. Excel Discussion (Misc queries) 5 July 25th 08 08:54 PM
Naming Auto Shapes and Creating new Shapes AL2000 Excel Discussion (Misc queries) 3 September 10th 07 04:12 AM
When drawing shapes in excel the shapes keep disappearing Tape Excel Discussion (Misc queries) 1 October 6th 06 04:23 PM
How can i get more 3D shapes for Auto shapes in excel? Ajey Excel Discussion (Misc queries) 0 March 3rd 05 09:53 AM


All times are GMT +1. The time now is 04:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"