While I was creating an Action section and Rows with VBA, I used the macro recorder and when I add a new row in the Action section, it generates code that seems to add along with the common cells we know a Prompt cell and an Help cell, like this:
Application.ActiveWindow.Shape.CellsSRC(visSectionAction, RowNum, visActionPrompt).FormulaForceU = """"""
Application.ActiveWindow.Shape.CellsSRC(visSectionAction, RowNum, visActionHelp).FormulaForceU = """"""
These cells doesn't show in the Action section. Does anybody know where they come from, if are they functional and if so which functionality they have? I couldn't find any reference to this.
Regards
All sections have unused cells! For example if you run this macro for some shape, which have Action section.
Sub test()
Dim i As Integer, sh As Visio.Shape
Set sh = ActiveWindow.Selection(1)
For i = 0 To sh.Section(visSectionAction).Row(0).Count
Debug.Print i, , sh.CellsSRC(visSectionAction, 0, i).Name
Next
End Sub
you get output like this
0 Actions.Row_1
1 Actions.Row_1._Unused1
2 Actions.Row_1._Unused2
3 Actions.Row_1.Action
4 Actions.Row_1.Checked
5 Actions.Row_1.Disabled
6 Actions.Row_1.ReadOnly
7 Actions.Row_1.Invisible
8 Actions.Row_1.BeginGroup
9 Actions.Row_1.FlyoutChild
10 Actions.Row_1I11
11 Actions.Row_1J11
12 Actions.Row_1K11
13 Actions.Row_1L11
14 Actions.Row_1.TagName
15 Actions.Row_1.ButtonFace
16 Actions.Row_1.SortKey
17 Actions.Row_1P11
PS This screenshot describe which constants used for these cells !
Other than the mystery of it all, is there anything useful
Sometimes i use this trick, just write formula with SETF via macro in cell which dont displayed in ShapeSheet.
For example prevent change cell's value to 0.
Set sh = ActiveWindow.Selection(1)
sh.CellsSRC(visSectionAction, 0, visActionPrompt).FormulaForceU = "SETF(GetRef(LockDelete),GUARD(1))+DEPENDSON(NOW())"