bVisual

Visio

Published on by

New Requirement for VBA Digital Signatures in Visio

Like most developers, I have to buy a new digital certificate every 3 years to sign my Visio add-ins and VBA projects. Usually that means verifying my bone fides, paying the fee and downloading the certificate, but security has been increased, and now, like everyone else, I have to use a USB key with it on (see Code signing changes in 2023 (digicert.com)). This requires the use of an application such as one from SafeNet that enables the signing of code. This is working for my Visio addins written with Visual Studio, but the VBA macros appeared to be signing until I tried to save the document. I was unable to save the document with the certificate applied:

[Read more…] about New Requirement for VBA Digital Signatures in Visio

Published on by

Custom Color Themes in Visio?

I was recently looking into custom color themes for corporate branding in desktop Microsoft Visio and became re-aware how different Visio still is from the rest of the Microsoft Office applications. A Visio page or document does not need to have any theme applied, but the documents of the other Office applications always have a theme. This means that custom theme colors are not available in Visio until a theme is selected, because custom theme colors rare a variation of a theme. This should not be necessary all the time, so I tried to produce a way of having an approved swatch of colours in a document, from which the individual colors can be copied.

[Read more…] about Custom Color Themes in Visio?

Published on by

Moving Phases/Separators in Visio Cross-Functional Flowcharts?

I use Visio Cross-Functional Flowcharts a lot, but there is one thing that really bugs me … you can move function bands\swimlanes around, but you can’t move the phases\separators in the same way. The phases/separators are containers just like the function bands\swimlanes, so why can’t I move them? Actually, it is quite understandable when you realise what is actually going on … both are contained within the Cross-Functional Flowchart (CFF) shape, but there are list containers between each band and the parent CFF shape.

  • CFF Container shape
  • Function band\Swimlane List shape
  • Swimlane shape
  • Phase List shape
  • Phase\Separator shape
[Read more…] about Moving Phases/Separators in Visio Cross-Functional Flowcharts?

Published on by

Using Notepad++ to Edit Visio ShapeSheet formulas

Visio shapes get their smartness from the formulas that are entered into the ShapeSheet, but editing these formulas can be extremely tricky and prone to error because of the lack of a modern programmer’s interface. Formulas can be quite long (up to 64k characters) but even medium size ones like the one in User.GetWorkdays cell below from an earlier article can become a challenge. I have been using Notepad++ for many years to copy and paste the formulas from a cell so that I can split the text into multiple lines, and to see where the bracket pairs are. My good friend John Goldsmith pointed out that I can record a macro in Notepad++ and create a custom language style. So together we improved our environment for editing ShapeSheet formulas.

  • ShapeSheet Design | Edit Formula dialog
  • Showing Intellisense
  • Copied and pasted into Notepad++
[Read more…] about Using Notepad++ to Edit Visio ShapeSheet formulas

Published on by

Adding a second Function header bar to Visio swimlanes

I was recently asked if a second function header bar can be added to the swimlanes in the cross-functional flowchart templates in Visio. Some swimlanes can get quite wide, so it can be useful to have a duplicate function header shape on the far-side too. It is quite simple to duplicate the existing function header sub-shape and then change its position to the opposite side of the swimlane.

[Read more…] about Adding a second Function header bar to Visio swimlanes

Published on by

More Parsing XML Data in Visio Shapes

My last article looked at parsing an XML string with a known structure and order of elements and attributes. This can be acceptable in some scenarios, but what if the elements or attributes are in a different order? Then it is necessary to use the element and attribute names rather than their index position. This requires a little more complexity to the ShapeSheet functions, and this can result in longer processing time, so needs to be used cautiously, but it is possible, as I demonstrate in this article.

  • Books group shape contains 20 child book shapes
  • Main functions in the document ShapeSheet
  • Called from cells in the group shape
  • Child shapes call functions in the parent shape
[Read more…] about More Parsing XML Data in Visio Shapes