April 15, 2015
Yesterday I got a bit of a shock which jolted me out of my usual Excel reverie. In carrying out my volunteering tasks and compiling a list of agencies that had received food relief from Wodonga Foodshare for the month, and pressing Ctrl-Shift-G to launch the macro I had designed which reduces the burden of completing this task, I got up on the screen a table of Workbook Statistics for the workbook I had open at that point. I understand that this table is a new feature available in Office 365. I searched my list of macros for other macros, designed by others, which may have enabled this action, and found none. I always understood that user assigned key combinations over-rode the default combinations that are a part of Excel. Is this not so?
Here’s the update, (two days later):
I noted from the Developer/Macros list, (see attachment), that the names of many of my macros had changed, and even though I had selected ‘show macros in the Food Out workbook’, (which was my active workbook), Food Out 2021 still appeared in the name of the macro, and the name was repeated. Going to the edit screen for individual macros showed nothing amiss, that the name of the macro appeared just once, as Sub MacroName(). Editing these OK names of each macro returned each to the land of the living, and all the macros then worked normally, responding to their assigned key combinations as I intended.
So, do you have any ideas as to what has gone on here, and the steps that I can take to prevent any recurrence. I suspect that using the Application.OnKey method could suffer from the same problem. (I understand that this is a very tall order, as you have no info on other macros that I have run.)
Any suggestions you can offer would be very much appreciated.
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Excel Customer Service
November 8, 2013