I read somewhere in this forum that to hide a grid column:-
put col. width to zero; you can search this forum for details
With mshflexgrid1
.Redraw = False
' place the columns in the right order
.ColData(0) = 0
.ColData(1) = 1
.ColData(2) = 2
' modify column's headers
.TextMatrix(0, 0) = "NAME "
.TextMatrix(0, 1) = "TITLE"
.TextMatrix(0, 2) = "RANK"
' set grid's column widths
.ColWidth(0) = 2500
.ColWidth(1) = 2500
::::::::::::
.Redraw = True
End With