shape: finding link to master stencil shape?

J

jeff_porter

Is it possible...

to find the master object in the stencil from a shape on the page?

The reason is...

I'd to like to set a property on the master shape in the stencil, that
can be read when I examine each shape on a page.*

I'd also like to then change the value of the property on the master, so
that it can be read on each instance on the page.

* I can do this by setting the prompt value on the master, and access it
via 'shape.Master.prompt', this thought doesn't get updated when I
change the value on master shape in the stencil.

Anyone have ideas?

Thanks
Jeff.
 
J

jeff_porter

John said:
Hello Jeff,

shp.Master.NameU will return a shape instance's Master name. However I'm
not clear on what you're trying to achieve. If you've changed a Master cell
and want its instance shapes to be updated when they've previously contained
local values the you could try the following:

Sub UpdateMasterInstances()
Dim shp As Shape

For Each shp In ActivePage.Shapes
If Not shp.Master Is Nothing Then
If shp.Master.NameU = "Process" Then
shp.CellsU("User.MyCell").FormulaU = "="
End If
End If
Next shp

End Sub

Does that answer the question?

Best regards

John


John Goldsmith
www.visualSignals.typepad.co.uk
www.visualSignals.co.uk

Hi John,

that sort of answers my question.
I'm gonna have a play and see if I can get what I want to work.

Cheers
Jeff
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top