Stack Overflow
Stack Overflow

Questions tagged [shapesheet]

The ShapeSheet is a spreadsheet-like environment, which is part of Microsoft Visio. It allows a shape to have its appearance and behavior controlled parametricly using constant values and expressions. This tag should be used for Visio related questions where the problem concerns ShapeSheet access and syntax.

Behind every Shape (and in fact, Page and Document), sits the ShapeSheet. It is the interface for most of the properties of a Shape that effect the shape's apprearance and behavior.

Although it is a visible part of Visio's UI, it also represents the conceptual structure of a shape's properties.

Most of the cells that you find in the ShapeSheet are the only means of accessing that particular attribute of a shape. So even if you're writing code against Visio you still need to address these cells via the CellsU and CellSRC properties on the shape object.

enter image description here

55 questions
1
vote
2 answers

Add Menu Action Programatically to Visio

I'm creating a macro to add a menu button to a selected Visio shape object, so whenever the user right-clicks on the box, an option will appear and will call a macro. I created a couple of properties to the object, which will be used by the action…
rlc
  • 5,809
  • 5
  • 38
  • 46
1
vote
2 answers

Visio stencil/shape text box is hidden - need shown

I've downloaded and am using the VNX 5300 stencil/shape from https://download.emc.com/downloads/DL38235_VNX_Visio_Stencil.zip (I had to create a free account to download it). I can hit F2 to edit the text, as normal, but it will not display. On…
Jon8RFC
  • 85
  • 1
  • 8
1
vote
1 answer

Create a Unique ID for a Visio Shape use the Shape Sheet

I'm not new to Visio nor to programming but I am new to developing in Visio. I'm using 2007 and am creating my own custom shapes with Shape Data. I want to create a UniqueID for all my shapes in the context of the drawing. I have created a Shape…
Scott M
  • 7
  • 1
  • 3
1
vote
1 answer

How do I add an action to Visio (2003)?

In a Visio ShapeSheet, one can add actions. I want to create an action that updates the value of another cell (the position of a control). How can one do that? Does it need a separate macro, or can it be specified directly? And how?
Paul de Vrieze
  • 4,888
  • 1
  • 24
  • 29
1
vote
1 answer

Visio VBA Get BoundingBox of Text

I have a shape in Visio which is a group. The group shape can have its text edited, and when it's edited I want one of the child shapes to sit just to the right of the text in the group shape. To do this, I created a VBA function that takes the…
Jon Fournier
  • 4,299
  • 3
  • 33
  • 43
0
votes
1 answer

Visio check if shape has a hyperlink

I have shapes that I want to change the format based on if they contain a hyperlink. This question solves this with VBA, but I'm wondering if this is possible with shapesheets only. It seems to be possible to check if Hyperlink.Row_1 exists. But as…
Michiel
  • 57
  • 1
  • 6
0
votes
1 answer

How to let visio shapes change behaviour from their text?

I have shapes that should change behaviour on the basis of their text. Text fields change their height and with using =GUARD(TEXTWIDTH(TheText)) just fine. But when I try to let something change color like this…
Michiel
  • 57
  • 1
  • 6
0
votes
1 answer

'Action' column of Visio document shapesheet won't retain "CALLTHIS(...,,)"

I wish to add an option which runs a macro to a Visio document's context menu. To do this, I have added a row to the Actions section of its shapesheet, with "Do X" in the Menu column. I can now see this option in the context menu when I…
IanW
  • 23
  • 4
0
votes
1 answer

Creating a WHILE Loop in Visio ShapeSheet

I'm aware that this can be easily done using VBA, but I'd like a macroless solution if possible. I have 2 User rows in a Shape's ShapeSheet: User.Count and User.Loop. User.Count will simply store a number, and the While loop will be performed by…
Vince
  • 467
  • 3
  • 8
0
votes
1 answer

Set Container font size using Visio VBA

I have code that is generating containers for a VBA diagram. I need to specify the font size for each container from VBA. For container shape con, I'm trying: con.Cells("Char.Size").FormulaForceU = "8 pt" This will cause the font size drop-down…
Hank Brandenburg
  • 319
  • 3
  • 12
0
votes
2 answers

VBA Visio select objects by color

I would like to select the objects by the color. So far I did something like this: If Vshp.CellsU("FillForegnd").FormulaU = "RGB(128,128,128)" Then sel.Select Vshp, visSelect End If But I see no reaction at all. I picked it from here: Visio…
Geographos
  • 827
  • 2
  • 23
  • 57
0
votes
1 answer

How to display Visio Document level Shape Data in Sheet Shapes like a text box etc

I'm trying to create a Visio template file where certain Document level Shape Data is populated and synced by another system. In this template I'm trying to add the value in Document Shape Data "Prop.BS_ID" into a text box using "Insert Field" and…
Fnk
  • 50
  • 7
0
votes
0 answers

Visio: Have shapesheet value on background, but show currentpage value

Looking for a way to have a field on the background page, to change value when switching to other pages. Example. I have a titlebox on the background page, and a user-defined field that shows ISO pagesize (A1, A2, Etc) with the following…
Bengt
  • 65
  • 1
  • 7
0
votes
2 answers

Visio Master Shape Data - dropdown from database

I have a seemingly straightforward Visio question that I am trying to find out if it is even possible to achieve: Can I create a set of master shapes, with each master shape representing a type of 'thing', for example it could be that one shape…
The Frog
  • 85
  • 7
0
votes
2 answers

Visio Shape Text positioning below the shape using Text Transform

I have a building a set of stencil shapes and I need the text to display below the shape. I am using custom formulas to generate the text, and as such the volume of text changes from use case to use case. What I have come across is using the Text…
The Frog
  • 85
  • 7
1
2
3 4