Color change - Cell Pointer
I got this macro to change the color of the cell pointer from this NG posted
by Mr. Bob Phillips long time ago. The macro works if its in the workbook.
Can it be modified so if you paste the macro in your Personal worksheet, it
will work on any workbook?
Private Sub Workbook_Open()
ReDim OldRng(20) 'allow for up to 20 worksheets
Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target
On Error Resume Next
Set ThisRng = OldRng
If Not ThisRng Is Nothing Then
ThisRng.Interior.ColorIndex = xlNone
Target.Interior.ColorIndex = 6 'yellow
Set OldRng = Target
Leave a comment...
- 1 Comments
- Good evening Danny
You could put the code in an add-in so that it is invoked every tim
you open Excel - that way it will be available in every worksheet yo
open and you won't get that message telling you that macros are presen
in a file.
Just note that as the code uses VBA every time a cell is changed, you
undo button becomes redundant - as long as you can live with that.
dominicb's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1893
View this thread: http://www.excelforum.com/showthread.php?threadid=39917#1; Wed, 04 Jun 2008 15:07:00 GMT