Feedback by UserVoice

How can we improve Excel for Mac?

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).

29 votes
Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)

We’ll send you updates on this idea

David James shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

1 comment

Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)
Submitting...
  • Anonymous commented  ·   ·  Flag as inappropriate

    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!

Feedback and Knowledge Base