Error 400 on executing macro first time in terminal server

Has know of an issue where the first time a macro is executed in a
terminal server that a 400 error occurs?

I tried adding "On Error Resume Next" but that didn't help.

The workbook works fine when used locally.

Thanks.

Macro does what?
What's the text of the error?

Tim

<gimme_this_gimme_that@yahoo.com> wrote in message
news:1142448797.618618.149740@i39g2000cwa.googlegroups.com...
> Has know of an issue where the first time a macro is executed in a
> terminal server that a 400 error occurs?
>
> I tried adding "On Error Resume Next" but that didn't help.
>
> The workbook works fine when used locally.
>
> Thanks.
>

This one does it:

'user changes a selection on a worksheet dropdown

Sub SetScrollRow()
Dim drp As DropDown
Set drp = ActiveSheet.DropDowns("RHFA_DETAIL")
ActiveWindow.ScrollRow =
Sheets("Navigation").Range("rhfa_details").Offset(1,
drp.ListIndex).Value
End Sub

And what's the text of the error message? - the number is less useful.

Tim


***********************
This one does it:


'user changes a selection on a worksheet dropdown


Sub SetScrollRow()
Dim drp As DropDown
Set drp = ActiveSheet.DropDowns("RHFA_DETAIL")
ActiveWindow.ScrollRow =
Sheets("Navigation").Range("rhfa_details").Offset(1,
drp.ListIndex).Value
End Sub

There is no text.

There is 400 and an X.