Col Delane,
Thanks for the great macro...just having one issue. For some reason when I run it, it gets stuck with "Adjusting comments on..." in the Status Bar, and doesn't actually change anything with the comments. I've tried waiting several minutes (and it's a very minimal spreadsheet), but the status continues Adjusting but not making changes. The result is the same whether I choose All Sheets or Active Sheets. I've also tried it in an xls (rather than xlsm). I can work in the spreadsheet without issue, I just have to close it to disable the macro/status.
FYI, if I run Faith Granger's original, I get a run-time error -- Method 'AutoSize' of object 'TextFrame' failed.
I'm not too familiar with VBA or Macros, so maybe it's something simple? Using the latest version of Excel for Mac. Thanks:)
Col Delane,
Thanks for the great macro...just having one issue. For some reason when I run it, it gets stuck with "Adjusting comments on..." in the Status Bar, and doesn't actually change anything with the comments. I've tried waiting several minutes (and it's a very minimal spreadsheet), but the status continues Adjusting but not making changes. The result is the same whether I choose All Sheets or Active Sheets. I've also tried it in an xls (rather than xlsm). I can work in the spreadsheet without issue, I just have to close it to disable the macro/status.
FYI, if I run Faith Granger's original, I get a run-time error -- Method 'AutoSize' of object 'TextFrame' failed.
I'm not too familiar with VBA or Macros, so maybe it's something simple? Using the latest version of Excel for Mac. Thanks:)