Macro error at cell: ScDataWorksheet!

[sosjames11]

Hi all,
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
When my users open or close files I create for them they get the following Macro Error Box. (Some users do not get the Error Box)<o></o>
<o></o>
Macro error at cell: <o></o>
[AnyFile.xls]ScDataWorksheet!A6<o></o>
Button Options: Halt, Step, Continue, Goto<o></o>
<o></o>
We all use Office 2007 sp2, running on XP Pro<o></o>
<o></o>
Has any one ever seen this?<o></o>
<o></o>
Seems like I have back when Office 2007 came out and I found some kind of registry fix, but I've slept since not really sure.<o></o>
<o></o>
Any ideas to get rid of this would be appreciated!!!

 

[Tom Urtis]

It might depend on any code the workbook has that is related to events of open, close, activate, or deactivate. Example, if ScDataWorksheet is hidden and such code aims to select cell A6 of that hidden worksheet, it's an impossible task and would result in an error.

So, look at any code in the workbook module, or sheet module of the ScDataWorksheet sheet, and post the code here so people can give you a suggestion. Although, chances are if you look at that code you'll be able to determine on your own what the problem is.

It might also be due to other reasons, such as those users closing all of Excel when other workbooks are open, and this workbook has something done to it with code in other workbooks executing as they close.

Hard to diagnose from a distance, these are just a couple blind suggestions.

 

[sosjames11]

Resolved

Thank you Tom,

This ended up being a missing ShowCase Query Add-in used for Querying an IBM iSeries Database. Which is still used in 2018 so I thought I would come back an answer.

 

[Tom Urtis]

Wow, an 8 year follow-up; now that is dedication to a solution cause. Thanks so much for the update.