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.

Error 400 on executing macro first time in terminal server
 

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.

Error 400 on executing macro first time in terminal server
 

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

Error 400 on executing macro first time in terminal server
 

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

Error 400 on executing macro first time in terminal server
 

There is no text.

There is 400 and an X.

Error 400 on executing macro first time in terminal server
 

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.