Error 400 on executing macro first time in terminal server

  • Thread starter Thread starter gimme_this_gimme_that
  • Start date Start date
G

gimme_this_gimme_that

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
 
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.
 
Back
Top