If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Link shape behavior to another shape on page
I have 20 custom shapes on a page, with one that I call the Master Control
shape. Each shape is a grouping of smaller shapes (a one big rectangle with 4 smaller rectangles inside) When I make formatting changes to the Master Control shape, I want that change reflected in the other 19 shapes. For example, if I change the text color to red in the smaller upper right coner rectangle, I want the other 19 shapes to reflect the same change. I think that I need to reference the "Character" row in the shapesheet, either with VBA or some function call. I tried using a function like Sheet.1!Charachter.Color but that doesn't work. Thanks! |
#2
|
|||
|
|||
Link shape behavior to another shape on page
Assuming "Sheet.1" is the desired controlling shape, then you're on target,
except the syntax is: Sheet.1!Char.Color. Wapperdude "MikeZ" wrote: I have 20 custom shapes on a page, with one that I call the Master Control shape. Each shape is a grouping of smaller shapes (a one big rectangle with 4 smaller rectangles inside) When I make formatting changes to the Master Control shape, I want that change reflected in the other 19 shapes. For example, if I change the text color to red in the smaller upper right coner rectangle, I want the other 19 shapes to reflect the same change. I think that I need to reference the "Character" row in the shapesheet, either with VBA or some function call. I tried using a function like Sheet.1!Charachter.Color but that doesn't work. Thanks! |
#3
|
|||
|
|||
Link shape behavior to another shape on page
That worked!
As a follow up, where is the reference or documentation on this type of coding technique? Maybe it is in the Visio Help, but I don't know how to search for it. Thanks again. "WapperDude" wrote: Assuming "Sheet.1" is the desired controlling shape, then you're on target, except the syntax is: Sheet.1!Char.Color. Wapperdude "MikeZ" wrote: I have 20 custom shapes on a page, with one that I call the Master Control shape. Each shape is a grouping of smaller shapes (a one big rectangle with 4 smaller rectangles inside) When I make formatting changes to the Master Control shape, I want that change reflected in the other 19 shapes. For example, if I change the text color to red in the smaller upper right coner rectangle, I want the other 19 shapes to reflect the same change. I think that I need to reference the "Character" row in the shapesheet, either with VBA or some function call. I tried using a function like Sheet.1!Charachter.Color but that doesn't work. Thanks! |
#4
|
|||
|
|||
Link shape behavior to another shape on page
try here
http://msdn.microsoft.com/en-us/libr...ffice.10).aspx al "MikeZ" wrote in message ... That worked! As a follow up, where is the reference or documentation on this type of coding technique? Maybe it is in the Visio Help, but I don't know how to search for it. Thanks again. "WapperDude" wrote: Assuming "Sheet.1" is the desired controlling shape, then you're on target, except the syntax is: Sheet.1!Char.Color. Wapperdude "MikeZ" wrote: I have 20 custom shapes on a page, with one that I call the Master Control shape. Each shape is a grouping of smaller shapes (a one big rectangle with 4 smaller rectangles inside) When I make formatting changes to the Master Control shape, I want that change reflected in the other 19 shapes. For example, if I change the text color to red in the smaller upper right coner rectangle, I want the other 19 shapes to reflect the same change. I think that I need to reference the "Character" row in the shapesheet, either with VBA or some function call. I tried using a function like Sheet.1!Charachter.Color but that doesn't work. Thanks! |
Thread Tools | |
Display Modes | |
|
|