Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Active chart refreshes slower in 2007 | Charts and Charting in Excel | |||
Button that refreshes all pivot tables at once | Excel Discussion (Misc queries) | |||
Can I insert a link to picture that refreshes when image file cha | Excel Discussion (Misc queries) | |||
Workbook Refreshes For Multiple Users | Excel Worksheet Functions | |||
Excel link to data in other worksheet only refreshes one column | Excel Discussion (Misc queries) |