Monday, 11 January 2016

Excel VBA Macro to Hilight Cursor



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