Can I Layer worksheets??

[Guest]

I have an application which requires me to have mutiple layers.

What I means is:

1) I have a single cell which is large in size. I have people drawing
objects in that cell. They will be drawing objects (circles, lines, etc)
for item #1 and then draw objects for ittem #2. If I had Items #1 on Layer 1
and Item#2 on Layer 2, I could make Layer 1 visible or Layer 2 visible or
both visible.

2) I would like the ability to change which Item is showing or have both
items showing at the same time.

3) I have the flexiability to use different color or Item #1 or #2 if that
would help.
Thre is also a multipage concept. Would that help???


Thank You!

Gary

 

[Dave Peterson]

I don't think so.

How about using a special name for each drawing object:

DrawingA_L01
or
DrawingA_L02

Then you could use a macro that would hide/show the objects based on the suffix
in the name.

 

[Guest]

Clarification:

What do you mean by a different Macro?? The drawing objects are generate by
a user using a tablet.

I normally think of a macro as code??

Thanks,

Gary

 

[Dave Peterson]

I don't see where I said "different", but what I meant was that if you named the
shapes nicely, you could use a macro to inspect each shape, check the name and
hide/show it based on what the code found.

 

[Guest]

I understand now??

Is there a way of pre-defining the object names adhead of times for my user??

Would I have to set up a macro (the user will select) to names these objects
for layer 1 differently from those objects used for layer 2??

Could I also do it with color?? Have one with a certain color and the other
set of objects with a different color.

Thanks,

Gary

 

[Dave Peterson]

I don't know of any way to set up the names beforehand, but you could base your
code on the fill color.

Take a look at Ron de Bruin's site:
http://www.rondebruin.nl/controlsobjectsworksheet.htm

He has lots of sample code there.

I understand now??

Is there a way of pre-defining the object names adhead of times for my user??

Would I have to set up a macro (the user will select) to names these objects
for layer 1 differently from those objects used for layer 2??

Could I also do it with color?? Have one with a certain color and the other
set of objects with a different color.

Thanks,

Gary

 

[Bill Sharpe]

I have an application which requires me to have mutiple layers.

What I means is:

1) I have a single cell which is large in size. I have people drawing
objects in that cell. They will be drawing objects (circles, lines, etc)
for item #1 and then draw objects for ittem #2. If I had Items #1 on Layer 1
and Item#2 on Layer 2, I could make Layer 1 visible or Layer 2 visible or
both visible.

2) I would like the ability to change which Item is showing or have both
items showing at the same time.

3) I have the flexiability to use different color or Item #1 or #2 if that
would help.
Thre is also a multipage concept. Would that help???


Thank You!

Gary

Many drawing applications support layering directly -- bring to front,
send to back, etc. Why must your work be done in Excel?

Bill