farpoint spread 헤더 컬럼 개별 색 지정

참고 : http://blog.naver.com/PostView.nhn?blogId=jellavy&logNo=50131175762


Private Sub Command1_Click()
  
' Hide the row headers
'vaSpread1.DisplayRowHeaders = False

' Give the column headers a lowered three-dimensional appearance
' Specify the column headers
vaSpread1.Col = 2 '-1
vaSpread1.Row = 0
' Turn off the raised three-dimensional appearance
vaSpread1.TypeTextShadow = False
vaSpread1.BackColor = &H80FF&

' Set the lowered three-dimensional appearance
'vaSpread1.TypeTextShadowIn = True

' Set the background color
' blue, RGB(0, 0, 255)
'vaSpread1.ShadowColor = &HFF0000

' Set the shadow border color
' dark blue, RGB(0, 0, 128)
'vaSpread1.ShadowDark = &H800000

' Set the text color
' yellow, RGB(255, 255, 0)
'vaSpread1.ShadowText = &HFFFF&


End Sub

-------------------------------------------

추가내용...

배경색을 연달아 지정시 grid라인이 표시가 안되는 경우에는 아래처럼

.BackColorStyle = BackColorStyleUnderGrid를 지정해주면 배경색을 지정해도 그리드라인이 표시됨...

vaSpread1.row = -1:
vaSpread1.Col = 9:
  vaSpread1.BackColor = RGB(255, 198, 255):
  vaSpread1.BackColorStyle = BackColorStyleUnderGrid
   
vaSpread1.row = -1:
vaSpread1.Col = 10:
  vaSpread1.BackColor = RGB(255, 198, 255):
  vaSpread1.BackColorStyle = BackColorStyleUnderGrid