How to enable webAccess in Vmware esx host?
1) Check to see of the WebAccess Service is running
service vmware-webAccess status
2)If webAccess service no started then start it.
service vmware-webAccess start
3) If you want to enable the service permanently.
chkconfig –level 345 vmware-webAccess on
And
esxcfg-firewall -–enableService webAccess
to enable permanently in the vmware firewall
This site is dedicated to providing information on Information technology, E-Learning. English Teaching, Project Management, IT Auditor, Security, Cloud Computing, Networks, Business Intelligence, Business Development, Java, C#.Net and Android.
Monday, 6 June 2011
Sunday, 5 June 2011
How to change Excel cell color based on value from another column
Sub ShowRun()
Dim i As Integer
For i = 1 To 800
If Cells(i, 8).Value = "1" Then
Cells(i, 3).Interior.ColorIndex = 35
ElseIf Cells(i, 8).Value = 2 Then
Cells(i, 4).Interior.ColorIndex = 35
ElseIf Cells(i, 8).Value = 3 Then
Cells(i, 5).Interior.ColorIndex = 35
ElseIf Cells(i, 8).Value = 4 Then
Cells(i, 6).Interior.ColorIndex = 35
Else
'Cells(i, 3).Interior.ColorIndex = 16
End If
Next
End Sub
Dim i As Integer
For i = 1 To 800
If Cells(i, 8).Value = "1" Then
Cells(i, 3).Interior.ColorIndex = 35
ElseIf Cells(i, 8).Value = 2 Then
Cells(i, 4).Interior.ColorIndex = 35
ElseIf Cells(i, 8).Value = 3 Then
Cells(i, 5).Interior.ColorIndex = 35
ElseIf Cells(i, 8).Value = 4 Then
Cells(i, 6).Interior.ColorIndex = 35
Else
'Cells(i, 3).Interior.ColorIndex = 16
End If
Next
End Sub
Subscribe to:
Posts (Atom)