Link to home
Start Free TrialLog in
Avatar of Thomas Woehlke
Thomas Woehlke

asked on

Assigning a shapesheet Layers Value to a shapesheet scratch Value

How can I set cell value Layer 1 'pins'.Visibility (or print) on [Page-1] to cell value Scratch 1 X on [Page-2]? I've tried formulas like
Pages[Page-1]!ThePage!Layers...

Open in new window

. but could never find a proper way to reference either the 'Print' or 'Visibility' value. A brief web search does not seem to provide the answer I'm looking for.
Shapesheet-Cell-Referencing.png
Avatar of Thomas Woehlke
Thomas Woehlke

ASKER

Okay, So I've seemed to have figure the answer out at least partially, but I do have some more issues. The solution to the question is as follows. All I need to do to get the scratch cell to spit out the layer value is enter.
=Pages[Page-1]!ThePage!Layers.Visible[1]

Open in new window

The next question would be weather or not there is a way to reference the layer by name. I can see now that as I work on a document and add more pages and parts to the schematics that I will not be able to rely on a consistent layer numerical order so I'll need to be able to reference the layer by name.
ASKER CERTIFIED SOLUTION
Avatar of Scott Helmers
Scott Helmers
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial