When we are using excel for a presentation or teaching purpose it is essential that the cursor is to
be highlighted to grab attention.This macro will highlight what ever you select are move.And here is Excel VBA Macro do it.
Hlite Cursor Excel VBA Macro:-
Right Click Sheet-1 and Click View Code
Copy and paste the following
Option Explicit
Double Click "This Workbook" in VB window
Copy and paste the following
Option Explicit
Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Excel.Range)
Static OldCell As Range
If Not OldCell Is Nothing Then
OldCell.Interior.ColorIndex = xlColorIndexNone
End If
Target.Interior.ColorIndex = 6
Set OldCell = Target
End Sub
Now return back to excel the cursor will be highlighted were ever you move
Or
Simply download highlight cursor workbook
Enable the macro options and use it
Click Here to Download Hlite Cursor Excel Workbook
No comments:
Post a Comment