Simple query opens an unexpected workbook?

[Dougmeister]

A simple 3-line macro I made. I assigned a hotkey to it and put it on the ribbon (Excel 2013).

When I run it (via hotkey or icon on the ribbon), it opens an older version of the workbook in another folder on my hard drive.

How do I find out why it is doing this? I've searched for the filename, for "C:", etc, but am finding nothing. When I single step through the macro, it works as intended without opening the auxiliary file.

ActiveCell.Value = "xxxx"
Selection.Font.Color = -4165632
Selection.Rows.AutoFit

At the bottom of the Excel window, I can see a message saying "Linking... <filename>" before it opens a similarly (but not exactly) named file...

... help?</filename>

 

[mrhstn]

Have you looked in the ThisWorkbook and Sheet modules in your workbook, see if any code assigns a hotkey or triggers an event?

 

[Dougmeister]

Just checked and, no, nothing at all in ThisWorkbook, and nothing in the Sheet modules that would assign a hotkey or trigger an event.

 

[mrhstn]

Have you any linked workbooks, e.g. a formula, named range or data connection which comes from elsewhere?

 

[RoryA]

Have you tried deleting and recreating the ribbon item? It sounds like it's assigned the wrong macro.

 

[Dougmeister]

It eventually runs the correct macro (the 3 lines of code in the original post), but it opens the other workbook first... (?) Weird...

 

[RoryA]

But did you try deleting and recreating the ribbon item?

 

[Dougmeister]

No. I'll try it here shortly and post back.

 

[Dougmeister]

That totally fixed it! Thanks.

Bonus points: can you help me understand *why* this happened, why deleting it from the ribbon and recreating the icon fixed it, etc.?