Where did my code go?

[ransomedbyfire]

I wrote a few macros in a spreadsheet a few days ago and then set it, via the project properties window, to be an add-in. I also made a shortcut key for the macro.

Now, I cannot, for anything, find the Onkey code that sets the shortcut key for that macro. But the shortcut key still works. So, it has to be somewhere, right?

Can anyone help me?

 

[AlphaFrog]

One likely place to look would be in the Workbook_Open event procedure located in the ThisWorkbook module.

 

[Greg Truby]

If you set up the shortcut key via the interface (the macros dialog box) then it isn't "in your code" anywhere. It's part of the workbook's built-in property set. You'd have to edit it again using the same macro dialog box. If you have XL 2007 or 2010, then the file is XML, and you could conceivably access it. But I wouldn't know how. AFAIK, it'd take someone like Andy Pope or Ron de Bruin to unspool the XML and tell you how to find it by a means other than the dialog box.

 

[ransomedbyfire]

One likely place to look would be in the Workbook_Open event procedure located in the ThisWorkbook module.

Thanks for the suggestion. I have looked, and it is empty.

If you set up the shortcut key via the interface (the macros dialog box) then it isn't "in your code" anywhere.

Nope, I made it using the application.onkey code - I think. But thanks for the suggestion! (In case I'm remembering wrong, is there a way to know whether the key was assigned via user interface instead of code?)

 

[Greg Truby]

Nope, I made it using the application.onkey code - I think. But thanks for the suggestion! (In case I'm remembering wrong, is there a way to know whether the key was assigned via user interface instead of code?)

I'd have go through the list of macros in the dialog box and list them out. If there's a better way, I don't know it.

If you really are setting it using OnKey, then you should be able to just hit Ctrl+F in the VBE and set the search scope to Entire Project and search the entire project.

 

[AlphaFrog]

Thanks for the suggestion. I have looked, and it is empty.

Did you look at both the ThisWorkbook module of your .xla add-in and the ThisWorkbook module of the currently open workbook?

 

[ransomedbyfire]

Okay, so, apparently, I didn't code the shortcut key. Oops!

Thanks guys!