![]() |
|
|
|
#1
|
|||
|
|||
|
.
Here is another. It is called from ThisWorkbook_Open module. You should also close it in ThisWorkbook_BeforeClose module ... Code:
Option Explicit
Private eTime
Sub ScreenRefresh()
With ThisWorkbook.Worksheets("Sheet1").Shapes(1)
.Left = ThisWorkbook.Windows(1).VisibleRange(2, 2).Left
.Top = ThisWorkbook.Windows(1).VisibleRange(2, 2).Top
End With
End Sub
Sub StartTimedRefresh()
Call ScreenRefresh
eTime = Now + TimeValue("00:00:01")
Application.OnTime eTime, "StartTimedRefresh"
End Sub
Sub StopTimer()
Application.OnTime eTime, "StartTimedRefresh", , False
End Sub
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How do I stop check boxes moving rows when text wraps in an adjacent cell? | PatrickYork | Excel | 2 | 04-04-2018 11:23 AM |
Cannot get macro button to sort with merged cells on sheet
|
lonniepoet | Excel Programming | 3 | 02-04-2016 04:33 PM |
| data in some cells moving | Sherriann | Excel | 1 | 08-07-2013 06:52 AM |
How to stop letter body moving up and down
|
alankempster | Mail Merge | 2 | 09-13-2012 08:09 AM |
Moving formula range multiple cells when moving sum over one cell
|
FraserKitchell | Excel | 4 | 02-26-2010 10:38 AM |