Locating Edit Link from an AddinFile

[ptmuldoon]

I often email myself end of day a file from a work computer to then be able to continue that work at home.

My work PC has an Addin file I created a while back with various scripts and functions.

This morning when I opened my (macro enabled) excel workbook, the file is looking to link back to that Addin file that I do not have on this computer currently.

I could break the link, but would like to find where that link is located to learn how it happened in the first place.

So far I have tried the following but have not found it.

1. Viewed and searched all formulas.
2. Checked all the scripts and having nothing trying to call back to the addin file.
3. Checked all named ranges.

Any other thoughts on where to try and find it?

[Greg M]

Hi there,

Does your workbook contain any Forms controls (CommandButtons, ComboBoxes, CheckBoxes etc.) which might be linked to the AddIn? This one has caught me out before!

Regards,

Greg M

[ptmuldoon]

Hi there,

Does your workbook contain any Forms controls (CommandButtons, ComboBoxes, CheckBoxes etc.) which might be linked to the AddIn? This one has caught me out before!

Regards,

Greg M

I just found it, and that was basically the problem. I had copied a script out of the addin file into this specific workbook, but had not changed the script name. And also had a shape button assigned to that macro causing the issue.

I renamed that particular script and reassigned the shape to the new macro name, and now appears good.

[Greg M]

Hi again,

Many thanks for your feedback - glad to hear that things are working for you now.

Regards,

Greg M