sheet shifts up/down

[biggles]

hi noob,

i have an excel worksheet that is refreshed over the network every few minutes. I have observed that occasionally, the sheet moves a couple of rows up or down after refreshing of the data. this movement is quite random and sometimes more than half the sheet has moved out of the screen. thsi requires me to slide the sheet back in position to work on it. Very, very annoying.

Is there any way to lock the sheet on the screen so that it doesnt shift after refreshing data?

Please help.

regards

[biggles]

Hulloooo!!!!! anybody here?

OK probably there's no soln to the page hopping up and down.

Can someone debug this macro for refreshing the xl page every 30 secs

="SeaGreen"]Sub ImportData()
    Application.OnTime 
  Now + TimeValue("00:00:30"), "GetWebData"
End Sub

the error is "compile error. argument not optional" and the .OnTime is highlighted in blue.


SO can someone help.

thanks

[shg]

Application.OnTime Now + TimeValue("00:00:30"), "GetWebData"

or

Application.OnTime _
  Now + TimeValue("00:00:30"), "GetWebData"

[biggles]

thanks mod.

Ran the simple macro now after 30 secs it says that macro not found, though it has been saved and appears when i call up the macro, and is not changed when i enter into the macro.

something not right that i am doing?

thanks

[shg]

Is there a typo in the line where the macro reschedules itself?

[biggles]

hishg,

Typo? I'm not sure. i've done a copy-paste of ur codes (tried both of them).

why should the run command return a 'macro not found' when the macro appears in the tools>macro and one can edit/ enter it.