Bring back all the macro features lost in 2011 and 2016
With 2011 and especially 2016 many of the vital functions in VBA recording and editing were lost making the writing of VBA macros impossible. User forms, debugging and relative referencing were three such features lost.
I used VBA to add features not available in Excel. As a transcriber of old church records I enter a lot of pre 1900 dates. These must be in a special dd mmm yyyy format which used to be checked by macro. I also check other fields for CAPITALISATION and Proper Case. None of this is now possible.
The advanced issue of a new version does not list these vital features. Please fix it - or give me my money back for a crippled version (2016).
Beginning with the release of version 16.x in early 2018, we have aligned the VBA capabilities of Excel on Mac and Windows to a much greater extent than in the past. Hopefully this has addressed all the needs of this suggestion.
If there are specific issues that are not addressed, please update to the current version of Excel by going to Help > Check for Updates. If the issue persists, then please send feedback using the Send-a-frown button in the top corner of the app.
Bring back the recording of 2011 macro functions1 I use Excel macros to process results from our research studies, and the inability to record actions that switch between windows and open new sheets is just plain ridiculous!