主题：[求助]如何用代码设置表不显示行号

如题，谢谢

Tables("表A").grid.cols(0).visible = False

老师，只是不显示行号，但列还是要存在

下图中红色部分如何用代码进行设置？谢谢

此主题相关图片如下：qq截图20150924214718.png

还能用属性 RowHeaderVisible  属性

mark 表样式

 

Tables("表A").Appearance.ShowLineNumber = False
Tables("表A").Refresh

 

 

UserStyle
ShowLineNumber
UnchangedRowHeaderForeColor
AddedRowHeaderForeColor
ModifiedRowHeaderForeColor
LockedRowHeaderForeColor
LockedAddedRowHeaderForeColor
LockedModifiedRowHeaderForeColor
GridLineDirection
GridStyle
GridWidth
GridColor
BackColor
ForeColor
HighlightBackColor
HighlightForeColor
FixedBackColor
FixedForeColor
SelectedHeaderBackColor
SelectedHeaderForeColor
AlterRowBackColor
AlterRowForeColor
FrozenBackColor
frozenForeColor
FocusBackColor
FocusForeColor
ModifiedCellBackColor
ModifiedCellForeColor
CurrentRowBackColor
CurrentRowForeColor
GrandTotalBackColor
GrandTotalForeColor
Subtotal0BackColor
Subtotal0ForeColor
Subtotal1BackColor
Subtotal1ForeColor
Subtotal2BackColor
Subtotal2ForeColor
Subtotal3BackColor
Subtotal3ForeColor
Subtotal4BackColor
Subtotal4ForeColor
Subtotal5BackColor
Subtotal5ForeColor
EmptyBackColor
ShowLockTableIcon
ShowLockColumnIcon
ShowLockRowIcon
ShowSortIcon

老师，谢谢了，这些属性是在哪儿找到的，我无法一一对号入座，

另：行号颜色又是如何用代码设置的

自己读懂英文，基本能对应。

3楼图片中第三格，行号颜色又如何设置呢？谢谢

很明显啊

 

UnchangedRowHeaderForeColor
AddedRowHeaderForeColor
ModifiedRowHeaderForeColor
LockedRowHeaderForeColor
LockedAddedRowHeaderForeColor
LockedModifiedRowHeaderForeColor

哦，老师，英语太差了