How odd this has happened to me all of a sudden. Something has caused a macro enabled spreadsheet to suddenly produce this error. Fortunately someone has already experienced the samething and has posted this fix at
http://stackoverflow.com/questions/27591879/suddenly-several-vba-macro-errors-mostly-32809
We found success using the following approach.
- Open a blank version of excel.
- Disable ActiveX controls in Excel Options.
- Open the offending file. (Click through any error received upon open)
- Save the file as a new name.
- Activate ActiveX controls.
We found distributing this file after the steps above resolved the error for all users.
Hope this helps someone else.
Really does work. As if the Active X settings have corrupted the file.
No comments:
Post a Comment