I love spelunking through the Visio shapesheet and creating Visio shapes that are more than just plain clipArt. I use CellsSRC() to explore because I can iterate through an entire shapesheet and learn. Though CellsSRC sounds like Cells Source, it actually stands for Section, Row and Cell. Section is misleading. If you look at theContinue reading “Visio RowType?”
Category Archives: VBA
Visio Background Check
Another interesting question from the Visio section of Answers. The user wanted to find the background colour of a page. He was using the Backgrounds tab on the Design ribbon. This creates a background page with a name like VBackground-1. So, what he was looking for was the colour of the first shape on theContinue reading “Visio Background Check”
Stacking Shapes
One thing that is missing in Visio, is the ability to stack shapes. You can align shapes on the top, bottom, left or right edges, but you can not stack. To stack two shapes, you have to drag a guideline from the top ruler and then place the bottom edge of one shape on theContinue reading “Stacking Shapes”
I need an OED
I have enhanced the Visio stencil shapes so that each shape has custom properties (AKA Shape Data) that is pulled down to the various cells in the shape. I have also updated how the Control Handles that control the width of the cells work. So,I now have a stencil of Visio section shapes that IContinue reading “I need an OED”
ShapeSheet Shapes
A lot of people only know Visio as an app to create business diagrams with clip art and connecting lines. Some have realized you can connect the diagram to a data source like Excel and bring life to the content. Some have also realzed you can add embelishments to the shapes called Data Graphics thatContinue reading “ShapeSheet Shapes”
Visio Stencil Sort
One of the things I noticed when reviewing Visio’s User Voice was the request for being able to have the shapes (they are actually masters) in the stencils be sorted. This is some code I have for keeping the masters in the document stencil sorted. Here is the before and after.
Adding Shape Data to a series of new shapes
I have been playing with Visio Visualization in Power BI and the first step is to create a Visio drawing. Basically it is a bunch of shapes, but I need to add Shape Data to the new shapes, basically the key that will link the shape to the row of data in Excel. I couldContinue reading “Adding Shape Data to a series of new shapes”
Removing unwanted properties from a collection of masters
In addition to cleaning up how the masters looked, I also had masters that contained user and custom (AKA Shape Data) properties that were no longer needed. Again VBA was useful. So I used the following code to Public Sub CleanMasters() Dim vsoMaster As Visio.Master Dim vsoMasterCopy As Visio.Master Dim vsoShape As Visio.Shape For EachContinue reading “Removing unwanted properties from a collection of masters”
Clean up Visio Masters
Anyone who has created Visio masters may have noticed that the masters may require cleanup. When selecting a master to edit, you may notice that the edit window seems to be empty and you will need to center the image to bring it back in view. Other times, the shape is bigger than the pageContinue reading “Clean up Visio Masters”
Colour My World Part II
Visio does not handle rows well and lists easily in the shapesheet, you can not do basic things like sorting the rows. So I use my favourite list handling app, Excel. When I need to manage large amounts of shape data, I manage it in Excel and then use VBA to remove the old shapeContinue reading “Colour My World Part II”