Feedback by UserVoice

Excel for Windows (Desktop Application)

Welcome to the Excel for Windows (Desktop Application) feedback forum! This is the place for users to send us suggestions and ideas on how to improve. If you think you have found a bug, please send us feedback in-app instead! To do so, please click “File”, then “Feedback”, then “Send a Frown” in Excel. This way, we will get detailed information that will help us better diagnose the problem.

To help us build the best version of Excel ever, we have partnered with UserVoice, a third-party service, to create this site to hear your suggestions and ideas for the next version of Excel. Your use of the portal and your submission is subject to the UserVoice Terms of Service & Privacy Policy, including the license terms. Please do not send any novel or patentable ideas, copyrighted materials, samples or demos for which you do not want to grant a license to Microsoft.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Bring VBA into the modern world

    It would have a couple of stages.
    Stage 1: Get Visual Studio features into the VBA development environment.
    Stage 2: Fully integrate VBA into Visual Studio.
    Stage 3: Continually improve VBA until it is a modern langauge.

    Notes:
    VBA is probably the most used programming language in the world.
    It has so many established users that MS could really get big brownie points by continually improving the experience for users and developers. Why it has stagnated for so long I have never understood.

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

    We’ll send you updates on this idea

    86 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →

    I want to thank everyone for weighing in – none of us on the Excel team are surprised that this item is getting a lot of votes, and we have read all of the feedback in this thread. Extensibility in Excel is something that we are passionate about, and while we’ve been focused on other investments over the last few years (primarily around getting Excel onto more devices with versions for Mac, iOS, Android, and Windows 10), this is something we’ve been actively discussing as we figure out how to enable extensibility of those new platforms.

    As it stands, here’s our current position.

    First, VBA is very important to Excel, and we plan to keep it around for the foreseeable future. As we add new features to Windows Desktop and Mac versions of Excel (where VBA is supported), we’ll continue to add object model for those features (see http://dev.office.com/blogs/VBA-improvements-in-Office-2016),…

  2. Allow Excel to undo macro actions

    I understand that not every macro is undoable, but some should be. For example, "Selection.Interior.Color = 255" is not undoable at the moment, but should be since you could do the exact same thing from the Ribbon. This really discourages people from using the macro recorder, or even macros in general.

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

    We’ll send you updates on this idea

    7 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →

    This VBA integration with the undo stack is not something that we’re planning on doing (see the idea about bringing VBA into the modern world).

    Cheers,
    Dan [MS]

  3. cortana should have the ability to be completely disabled in all its functionalities

    cortana should have the ability to be completely disabled in all its functionalities

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →

    Cortana is not something developed by the Excel team, and unfortunately we don’t have the ability to pass this on to the Cortana team.

    Cheers,
    Dan [MS]

  4. Macro recorder should ignore selections

    It is well known that the macro recorder does not produce code that anyone should ever write themselves. For example, this recorded macro...

    Sheets("Sheet1").Select
    Range("A1").Select
    Selection.Copy
    Sheets("Sheet2").Select
    Range("A1").Select
    ActiveSheet.Paste

    ...can be simplified to this...

    Sheets("Sheet1").Range("A1").Copy Sheets("Sheet2").Range("A1")

    Since selection-ridden code is longer than necessary and inefficient while running, and since people rarely need their selections to be tracked, I feel that the macro recorder should skip selections entirely.

    Of course, if the selection triggers an event, such as Worksheet_Change, then the event handler (if any) can be called directly instead.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    declined  ·  0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  5. Seems currently a user cannot run a macro if the user puts a password protection at the workbook leve

    Seems currently if a user password protects the whole workbook, he/she cannot run the macros within the workbook (without compromising on security of system as explained in one of the posts from microsoft as workaround). Since it's a practical situation where due to sensitive information, a user may want to also password protect the excel while putting it on a shared lan/sharepoint, it would help if users could run the macro once they are in the workbook. I saw there were many users like me, who had this requirement but found no good solution on this. Hope you could acknowledge…

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    declined  ·  1 comment  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Feedback and Knowledge Base