I have some VBA code that is executed from the actions section of the shape sheet by using the RUNMACRO function. The code adds some shapes to the page based on the postion of other shapes in the selected group of shapes. It then changes a number of shapesheet values for the shape(s) that were added by the code. Many of the shape sheet formulas reference other shapes in the selected group.
If I make a MASTER from my group of shapes and then add multiple instances of the master will the VBA code work across the instances?
Here is a small sample snipet of the VBA code
.....
.....
strusercell = "room"
workstring = vsoShape.AddNamedRow(visSectionUser, strusercell, visTagDefault)
'Set vsoCell to the cell just created and set its formula.
Set vsocell = vsoShape.Cells("user.room")
strformula = "=guard(sheet.1!user.room)"
vsocell.Formula = strformula
...
...
Will the code work when a second instance of the master is added? i.e will the reference to sheet.1 be changed to the appropiate sheet number for the additional instances added, or am I out in left field?.

Thanks
Mike