Hi all,

Since Monday I have been having problems with VBA in Excel 2007 (running on Windows XP, SP2). I recorded a few very simple macros to change the shade of the selected cells to a specific color and assigned each a keyboard shortcut. I have done this before without difficulty and, in fact, have the same macros working perfectly at home.

What's been happening since then is that (1) the keyboard shortcuts aren't being recognized and (2) VB Editor opens itself up whenever I lock the computer to walk away for any period of time.

I first noticed that the shortcuts were disabled almost immediately after the modification of one macro's comments (e.g., ' ShadeCellGreen Macro changed to ' Description: Shade selected cells green.) or the relocation of the newest macro from Module1 to my BasicFormatting module and removal of Module1.

I closed out of Excel and restarted my computer and then added all the keyboard shortcuts back to all of the macros. Now, they're disabled again.

I vaguely remember my fingers getting away from me at one point while I was in VB Editor, so I'm sure that I caused all my woes. Will anyone take pity and help me figure out how to fix this?

These shortcuts are a huge timesaver for me, so I would really appreciate any help anyone can offer.