Change Cursor Image if Workbook is not the Active Window

  • Thread starter Thread starter RyanH
  • Start date Start date
R

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?
 
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
 
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?
 
Back
Top