I am a beginner so it is very possible that I was not assigning the macro properly. I followed your steps (for which I thank you for being so thorough), and still the macro name did not appear in the Macro Name field. Taking your suggestion that the file may be corrupted, I created a new Excel file, followed your steps, and this time the macro name assigned did not change, so it would seem that the file is indeed corrupted. Big bummer on the one hand, but on the other hand at least I now know what the problem is. Thank you very much for your help . . . . it is much appreciated!