I have a macro-enabled Excel 2010 workbook application that users can get from our webpage. When a user clicks the link to get the workbook they are presented with a "File Download" dialog box that asks if they wish to OPEN, SAVE, or CANCEL the file.
If user saves it to their PC all the vba code works just fine, and the application functions as expected. However, if they select OPEN then some users (not all) are getting runtime errors when the workbook opens.
Can anyone point me in the right direction on how to fix this issue?
All users are using Excel 2010