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 |
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) |