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

wrote in message
oups.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.

The problem turned out to be that one of the Subs used Me as a
reference.

Also Excel wasn't configured to provide Visual Basic a trusted security
certificate.