Table of contents
Collapse the table of content
Expand the table of content

Cell.FormulaForce Property (Visio)

office 365 dev account|Last Updated: 6/12/2017
1 Contributor

Sets the formula in a Cell object, even if the formula is protected with a GUARD function. Read/write.


expression . FormulaForce

expression A variable that represents a Cell object.

Return Value



Many of the SmartShapes symbols provided with Microsoft Visio have guarded cells to maintain their smart behavior. When you change the formula in a guarded cell, the shape's behavior might change in unexpected ways.

Note Beginning with Microsoft Visio 2000, you can use both local and universal names to refer to Visio shapes, masters, documents, pages, rows, add-ons, cells, hyperlinks, styles, fonts, master shortcuts, UI objects, and layers. When a user names a shape, for example, the user is specifying a local name. Beginning with Microsoft Office Visio 2003, the ShapeSheet spreadsheet displays only universal names in cell formulas and values. (In prior versions, universal names were not visible in the user interface.)

As a developer, you can use universal names in a program when you don't want to change a name each time a solution is localized. Use the FormulaForce property when you want to use local syntax in the formula. Use the FormulaForceU property when you want to use universal syntax in the formula.

© 2018 Microsoft