Removing GUARD from VBA

[lythamlatic]

I created a number of master objects which I wanted to protect (from colleagues who understand Visio even less than me) with GUARD used on the LockFormat cell. These objects have been used extensively, but I now would like to change something on them all - more fool me for trying to be clever.

Is it possible to remove GUARD under programme control? When I tried the below in a for-loop, I simply got the error "Cell is guarded."

Application.ActiveWindow.Page.Shapes.ItemfromID(i).CellsSRC(visSectionObject, visRowLock, visLockFormat).FormulaU="0"

[kiler40]

Hi There,

You whould use FormulaForceU

[lythamlatic]

Brilliant - I didn't know that one.

Thanks - that's saved me a lot of work.