Need help to troubleshoot Automation Error
 

I am looking at a spreadsheet that contains various macros and vba code. We
work in a Citrix enviornment with a published desktop. This means that each
time a user logs onto a desktop session, it is likely that they will hit a
different server each time.
On certain servers, when the spreadsheet is opened it works as expected. On
other servers, the spreadsheet opens and there is a Microsoft Visual Basic
pop-up box with the words "Automation Error". We are finding the error
difficult to troubleshoot, as we cannot pinpoint which part of the code is
triggering the error.
Any help in where to start looking would be appreciated.