My excel 2011 for Mac recently stopped recording macros properly. When run, they do not perform any actions. Upon inspecting them in the editor, I see that there is no information contained in the area where the action codes should be. (See example below). Yet all my existing macros run properly. I have also attempted to record sample macros from the support site, but these too have the same problem. Why are my new macros failing to record any steps I perform? Thanks For example: Sub AverageScoreNames() ' ' AverageScoreNames Macro ' Creates column headers of student names for table of their average scores ' ' End Sub
Solved by X. W. in 20 mins