How does one refreshes the screen?
 

I have protected a worksheet and disabled selection. The problem is
that cellpointer does not disappear from Range("A1") that I had
selected. If I have another application running eg notepad and place
notepad on top of Range(
"A1") the cellpointer disappears. Is there a way I can refresh the
screen in excel. My code is as follows


Sheet2.activate
Application.Screenupdating = true
With Sheet2
.Range("A1").Select
.EnableSelection = xlNoSelection
.Protect Contents:=True, UserInterfaceOnly:=True
End With

Thnak you
John

How does one refreshes the screen?
 

It did disappear for me (xl2002 and win98).

maybe adding a "doevents" to your code would help.

But since you don't want any selected cell, how about just

.range("iv65536").select

If it's off the screen, it should offer the same picture.



John wrote:

I have protected a worksheet and disabled selection. The problem is
that cellpointer does not disappear from Range("A1") that I had
selected. If I have another application running eg notepad and place
notepad on top of Range(
"A1") the cellpointer disappears. Is there a way I can refresh the
screen in excel. My code is as follows

Sheet2.activate
Application.Screenupdating = true
With Sheet2
.Range("A1").Select
.EnableSelection = xlNoSelection
.Protect Contents:=True, UserInterfaceOnly:=True
End With

Thnak you
John

--

Dave Peterson