Cell.FormulaForce property (Visio)

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



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.


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.

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.