How to reference the same object on more pages?

M

Michael

I know I have seen this before in the newsgroup, but at the time I wasn't
that far and now I can't find the message anymore.
How do I refence and object on more pages, so If I change the object on one
page it also gets changed on the other pages?

I want to be able to do this using VBA.

Scenario: I have one overall page and when the user selects certain
connections I want to regenerate a new page containing
only the relevant objects from the overall drawing.

Also, could some one have look at my earlier question about: Shapes and
graphics (Windows BMP) on july 22th?

Thanks in advace, Michael
 
M

Michael

Markus, thanks!
is it only possible to reference a single cell?

I want a 'ghost' of the whole original object/shape on another page, is that
possible?

Markus Breugst said:
Hello Michael,

if you have a Shape named "Sheet.1" on a page named "Page-1", then you can
reference one cell of this shape with

Pages[Page-1]!Sheet.1!CellName

where CellName is the name of a cell of "Sheet.1".

Best regards,
Markus


Michael said:
I know I have seen this before in the newsgroup, but at the time I wasn't
that far and now I can't find the message anymore.
How do I refence and object on more pages, so If I change the object on one
page it also gets changed on the other pages?

I want to be able to do this using VBA.

Scenario: I have one overall page and when the user selects certain
connections I want to regenerate a new page containing
only the relevant objects from the overall drawing.

Also, could some one have look at my earlier question about: Shapes and
graphics (Windows BMP) on july 22th?

Thanks in advace, Michael
 
M

Markus Breugst

Hello Michael,
I want a 'ghost' of the whole original object/shape on another page, is that
possible?

I don't think that this is possible. The only possibility I am aware of is
the one I described. But perhaps someone else has any idea?

Best regards,
Markus

Michael said:
Markus, thanks!
is it only possible to reference a single cell?


"Markus Breugst" <[email protected]> schreef in bericht
Hello Michael,

if you have a Shape named "Sheet.1" on a page named "Page-1", then you can
reference one cell of this shape with

Pages[Page-1]!Sheet.1!CellName

where CellName is the name of a cell of "Sheet.1".

Best regards,
Markus
 
M

Michael

What is a local master?
I like the idea, but it still sounds complicated.
The other line I am thinking of is using a database of all my objects and
store the userstuff there and keep that in sync with the drawings somehow...

Russ McKenna said:
The only way I can think of is by automation and local master.
You would modify the local master and not the instances of the shapes. All
this would be by automation. You could use the cellchange event, then via
automation update the master to that new cell value - it would then change
the instances values also - you would have to change the cells of the
instance shape you were modifing and what kicked off the cellchange event to
null so it inherits the default value - which you already changed back -
that way when ever the master changes the instance will change.

Markus Breugst said:
Hello Michael,
I want a 'ghost' of the whole original object/shape on another page,
is
that
possible?

I don't think that this is possible. The only possibility I am aware of is
the one I described. But perhaps someone else has any idea?

Best regards,
Markus

Michael said:
Markus, thanks!
is it only possible to reference a single cell?


"Markus Breugst" <[email protected]> schreef in bericht
Hello Michael,

if you have a Shape named "Sheet.1" on a page named "Page-1", then
you
can
reference one cell of this shape with

Pages[Page-1]!Sheet.1!CellName

where CellName is the name of a cell of "Sheet.1".

Best regards,
Markus
 
R

Russ McKenna

In order to use a database, you would still need a tool to interpret the
information to the shape.

Either way you will need to handle things, Visio does not have a built in
solution for you.

To explain master:
Visio is designed to try to take short cuts and save drawing memory. If
you drag a stencil onto a drawing, Visio thinks that you will use this shape
again, so it builds a local copy of this stencil. It takes the local copy
(local master) and then places it on the drawing. Think of this as just a
reference to the local master. When you make a change to the shape on your
drawing you are really saying to visio, use the local master but make these
changes. When you place the stencil again on the drawing, Visio sees that
you already have it as a local master, so it says use it instead. Confused
yet? Use the drawing explorer - menu View -> Drawing Exploring Window. This
will show you a tree view of your document. Look at the masters section, and
you will see the local masters defined. If it is blank, then you don't have
any, drag a stencil over to see a local master. Edit a master and see how
the instances change to fit the master. Remember, only the characteristics
that are 'same as master' will be updated. Those fields where you have said
'except', they will not update.

If you need info, reply.


Michael said:
What is a local master?
I like the idea, but it still sounds complicated.
The other line I am thinking of is using a database of all my objects and
store the userstuff there and keep that in sync with the drawings somehow...

Russ McKenna said:
The only way I can think of is by automation and local master.
You would modify the local master and not the instances of the shapes. All
this would be by automation. You could use the cellchange event, then via
automation update the master to that new cell value - it would then change
the instances values also - you would have to change the cells of the
instance shape you were modifing and what kicked off the cellchange
event
to
null so it inherits the default value - which you already changed back -
that way when ever the master changes the instance will change.
of
is
the one I described. But perhaps someone else has any idea?

Best regards,
Markus

Markus, thanks!
is it only possible to reference a single cell?


"Markus Breugst" <[email protected]> schreef in
bericht
Hello Michael,

if you have a Shape named "Sheet.1" on a page named "Page-1", then you
can
reference one cell of this shape with

Pages[Page-1]!Sheet.1!CellName

where CellName is the name of a cell of "Sheet.1".

Best regards,
Markus
 
J

John Marshall, MVP

M

Michael

Russ & John, thanks for the explanations!

Also I just received Grahams books, so I am reading a lot :)
 

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