Change Cursor Image if Workbook is not the Active Window

[RyanH]

I have a particular worksheet in a workbook, where I want the cursor to equal
xlNorthWestArrow. The problem occurs when I go to the VBE the cursor remains
as a arrow, but I need it to go back to xlDefault. Is there a Application
event that you can fire whenever a particular worksheet inside a particular
workbook is the active window the cursor will be xlNorthwestArrow and all
other times the cursor will go to xlDefault?

 

[Shasur]

Can you try the activate event of that particular worksheet like

Private Sub Worksheet_Activate()
Application.Cursor = xlNorthwestArrow
End Sub

Private Sub Worksheet_Deactivate()
Application.Cursor = xlDefault
End Sub

Cheers
Shasur

 

[RyanH]

I have tried that before and it does not work, because the Excel sees the
worksheet with the cursor code as the active worksheet although I am in the
VBE. I figured there has got to be a way to put the cursor code in an
Application event Window_Activate and Window_Deactivate. Is there such a
thing?