excel十字光标代码?excel中出现有颜色十字带状如何解决?
ByVal Target As Range)excel中出现有颜色十字带状如何解决?Alt+F11打开VBE编辑器, End With;End Sub用VBA代码隐藏的某些列如何再次显示出来;Columns("隐藏 Columns("D;取消隐藏 Rows("
excel十字光标代码?
PrivateSub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)
excel中出现有颜色十字带状如何解决?
Alt+F11打开VBE编辑器,双击对应的工作表对象,复制粘贴下面的代码后,在工作表中选中单元格时显示带颜色的十字。 Private Sub Worksheet_SelectionChange(ByVal Target As Range) Cells.Interior.ColorIndex = xlColorIndexNone With Target .EntireRow.Interior.Color = vbBlue .EntireColumn.Interior.Color = vbBlue End With End Sub
用VBA代码隐藏的某些列如何再次显示出来?
你确定是隐藏的吗?
Columns("D:E").Select Selection.EntireColumn.Hidden = True '隐藏 Columns("D:E").Select Selection.EntireColumn.Hidden = False '取消隐藏 Rows("2:7").Select Selection.EntireRow.Hidden = True Rows("2:7").Select Selection.EntireRow.Hidden = False
0