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?
--
Cheers,
Ryan

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

--
http://vbadud.blogspot.com


"RyanH" wrote:

> 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?
> --
> Cheers,
> Ryan

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?
--
Cheers,
Ryan


"Shasur" wrote:

> 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
>
> --
> http://vbadud.blogspot.com
>
>
> "RyanH" wrote:
>
> > 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?
> > --
> > Cheers,
> > Ryan