Sponsored Links


  • 1. How do you 'bend' text in Visio (i.e. so it follows a curve)
  • 2. Visio diagrams change when reopened.
    I have a problem diagram which has been created in visio 2000 that is updated regularly. The problem which occurs randomly is that when the Diagram is opened the colours and shapes have changed which in turn makes some object unreadable. The Visio file is large approx 2Gb and contains approx 20 worksheets however this is not uncommon and this problem only effects one visio file. The file is opened from a network share however once again not the only one. I have updated all the clients which open these files with all the latest service packs and hotfixes but so far i have had no joy. This is becomming a very time consuming problem I hope that some one can help me find the answer.
  • 3. Dotted lines in Crow's Foot notation in Visio 2003 - HELP!
    Database modeling with crow foot notation.The crow's foot notation is almost the only one meeting academic standards such as explained in the book 'Database Systems' , 4th Ed., T. Connolly, Addison-Wesley,2005. However I could not find the use of a dotted line to explain 'identifying' and 'non-identifying' relationships. Now I have spent a lot of time creating the diagram, but I need to get rid of the dotted lines unless I can show that anyone else other than Microsoft is using this concept. If you happen to know why this decision was made and whether there are academic publications or whitepapers related to the decision of using dotted lines to show the difference of Identifying Relationships, please email me immediately to ( XXXX@XXXXX.COM ).


Postby R2F6 » Thu, 16 Aug 2007 23:14:01 GMT

Hi, I'm trying to develop a Visio icon that can perform a few custom actions. 
Not that I know a lot about what I am doing but I had made some progress and 
now seem to have gone backwards !

In the icon's shapesheet, 3 "actions" are listed. One is labelled 
"Actions.PlayPhrase". The text in the action box I vary from attempt to 
attempt, but should be something that plays a .wav file.  As I look at it now 
it says PLAYSOUND("C:\Test.wav",0,1,1), and naturally when I select it from 
the icon menu it fails to play anything.

Ideally, eventually, I want to replace the direct path/filename with the 
"Prop.AudioFile" defined earlier in the shapesheet and labelled "AduioFile".

Does anyone have any suggestions on why the file isn't playing at the 
moment, and what I need to do to allow me to use "AudioFile" as the file to 
play ?


RE: ShapeSheet

Postby R2F6 » Thu, 16 Aug 2007 23:34:04 GMT

"and labelled "AudioFile"

Where's the modify post button ?

Re: ShapeSheet

Postby David Parker » Fri, 17 Aug 2007 00:12:00 GMT

I just tried:

Works fine, so I tried:
Prop.AudioFile.Value = "C:\Windows\Media\Chimes.wav"

That worked fine too!

Re: ShapeSheet

Postby R2F6 » Fri, 17 Aug 2007 00:26:03 GMT

Unfortunately it doesn't for me :-( 

However I did make some progress.  I left out the ,0,1,1 and it played !  
I'd swear I've tried that many times before but .... well: something must 
have changed somewhere.

Anyway I'm only part way there.  Changed the string to "AudioFile" and I was 
back to silence again, despite "AudioFile" being the label assigned to 
property Prop.AudioFile earlier, the value having been set to "C:\test.wav".

Re: ShapeSheet

Postby David Parker » Fri, 17 Aug 2007 02:50:09 GMT

You cannot use the Label of the property, you must use the name in the form:

Re: ShapeSheet

Postby David Parker » Fri, 17 Aug 2007 05:10:08 GMT


Re: ShapeSheet

Postby R2F6 » Sat, 18 Aug 2007 09:50:50 GMT

Thanks for explaining how it should work David, much appreciated.

Unfortunately it is one of the many variations I have tried, but without 
I shall try another few variations today and see if I can find one it "likes".


Re: ShapeSheet

Postby R2F6 » Tue, 21 Aug 2007 22:12:02 GMT

Just to finish off.  Once I knew the name I had to use, it turned out just to 
be a case of blundering along until I discovered there are times when the 
quotes are not needed. Now seems ok.

Thanks again.


Postby TWF0dA » Fri, 28 Sep 2007 05:43:01 GMT

Is there a way to chage the shapesheet address cell for all hyperlinks at one 
time in a visio file?  I have about 500 links that need to have the address 
cell content deleted and would prefer not to have to go into each one.
thanks for your help

Re: Shapesheet

Postby John Goldsmith » Fri, 28 Sep 2007 06:44:32 GMT

Hi Matt,

Have a go with the following code, which will run through all of the shapes 
in your document and set the address cell to "" irrespective of the type of 
hyperlink (let me know if they're not all the same):

Sub ResetLinkAddressCells()
Dim shp As Shape
Dim pag As Page
Dim i As Integer
For Each pag In ThisDocument.Pages
    For Each shp In pag.Shapes
        If shp.SectionExists(visSectionHyperlink, 0) = True Then
            For i = 0 To shp.Section(visSectionHyperlink).Count - 1
                shp.CellsSRC(visSectionHyperlink, i, 
visHLinkAddress).FormulaU = ""
            Next i
        End If
    Next shp
Next pag
End Sub

To run the above code try the following:

1) Create a copy of your document (just to ensure you're happy with the

2) Press alt+F11 to open the VBA editting window (VBE).

3) In the VBE click Insert / Module and paste the code above into the new
blank area on the right.

4) Press F5 to run the procedure and then check the results in the 
shapesheet (it should say "No Formula").

Hope that helps.

Best regards


John Goldsmith

Re: Shapesheet

Postby TWF0dA » Tue, 02 Oct 2007 23:31:00 GMT

Thanks John...this took care of all my issues....!!!!

Similar Threads:

1.Visio 2003 Shapesheet Help

2.Change default properties Shapes and shapesheet

2 questions
1) How can I modify the default properties of the shapes in my flowcharts? 
(eg. colour)
2) Is it possible that all the hyperlinks (from visio into Word) for all the 
shapes in my flowcharts always opens in a new window? Now i'd to change for 
every shape the shapesheet properties by the section hyperlinks "New Window" 
the formula on TRUE. That's a lot of work, alas.



3.Print the ShapeSheet in Visio 2002

Is there a way to print the shape sheet in Visio 2002 ?

4.Referencing an excel 'cell' value on the shapesheet screen

I have a value in an excel spreadsheet, Test.xls for example at cell 'A1', 
that I want to use in the PinX field of a shapesheet.  How do I reference the 
excel sheet in the shapesheet window?  I tried to use 
='Path\[Test.xls]Sheet1'!A1 to do this but it didn't work.

Thanks for all your help.

5.Shapesheet formula syntax (V2003)

I'm new to Visio Property Sheet use, am trying to create some compound
shapes, and need to figure out the 'trick' to referencing a shape by
name.  I'm working with named shapes (e.g. "Titlebar" versus 
for simplicity and general elegance (coder habit).  Per MSDN, I should
be able to use 'Name' (single quotes) in place of sheet.<id>.
However, the method suggested does not work.

Example:  While sheet.31!width works, 'MyShape'!width generates an
 "error in formula"* error.  I have tried
numerous variations and could get none to work.

Does anyone have a tested-and-known-good syntax sample for referencing
a shape by name?

Also, in case the ID is needed again, can the Drawing Explorer be told 
to display ID's?  I can't seem to find a simple way to learn a shape's 
ID once it's been named.

Thanks for any help,

* A tip of the hat to Microsoft for their religious adherence to the 
"Convey as little useful information as possible:" error message 
authoring philosophy.  "Error in formula" is probably second only to 
"OLE Error" in this regard :) 

6. Shapesheet formula syntax (Visio 2003)

7. ShapeSheet: Inserting a Custom Property & displaying it via Automation -- Visio 2002

8. stencils + shapesheet code + certificate??

Return to VISIO


Who is online

Users browsing this forum: No registered users and 94 guest