101 votes25 comments · Excel for Windows (Desktop Application) » Other · Flag idea as inappropriate… · Admin →Ken P commented
Yes!! Since this is either built in to most UI frameworks, or very easy to implement, it is almost as though the Excel team has put in effort not to do this. This would be a huge boost in efficiency.
23 votes1 comment · Excel for Windows (Desktop Application) » Macros and Add-ins · Flag idea as inappropriate… · Admin →Ken P supported this idea ·Ken P commented
In terms of completeness of macro recording, I would add correctly recording conditional formatting. Specifically, if I apply a conditional number format to a cell (for example, if A1 = "a" then the format for B1 is '#,##0.00_);(#,##0.00);"-"??_);@_)') it works correctly, but when recording the steps the format is applied unconditionally, and there is a line in the macro, ExecuteExcel4Macro "(2,1,""#,##0.00_);(#,##0.00);""-""??_);@_)"")", that fails. This makes no sense to me and should be considered an unacceptable result. Anything that is recorded should be able to be executed, given an identical starting workbook.