ok, so this seemed to be a very simple thing, so i wrote this….
Function CursorChange(State As String)
If State = “Reset” Then
Application.Cursor = xlDefault
ElseIf State = “Change” Then
Application.Cursor = xlNorthwestArrow
End If
End Function
simples! ……. or so i thought ! :huh:
Whilst this does exactly what is says on the tin, when you call CursorChange(“Change”) or “Reset”, what i wasn’t expecting it to do was change it’s behavior, let me explain…..
All i wanted was to get rid of that ugly-ass thick white cross that excel has as the default cursor when moving over the worksheet/spreadsheet area, i wanted the new selection to behave exactly the same as the original when i, say, edit a cell, in that it should switch to the I-Beam, or when i mouse over a control box that has a hand icon assigned, it should switch to that new icon.
Using the code above, does indeed change the cursor, but it also disables ANY other changes :rolleyes:
help !
(end goal was to get rid of the cross for the arrow, and then later see if i could change said cursor to a faded/grey one when i mouse over a locked sell)
