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.
-
Create a command line tool for signing Office files with a digital certificate
Besides Office, Excel files can be created using numerous software tools. More often than not, batches of macro-enabled Excel files are processed with scripts for productivity purposes. However, VBA code signing cannot be part of an automated process, as it is a manual task that requires opening & saving the file in Excel.
This request is about creating a command line tool for signing Office files with a digital certificate, similar to MS SignTool.
In addition, the existing macro signing process in Office is not 100% compatible with Open XML specifications. I can clarify this statement in a private discussion…
73 votes -
13 votes
-
Option to save VBA changes but not worksheet changes
Use case: in my world, we have templates that are frequently updated. As a result, the VBA has to be updated and tested as well. I'm not an expert programmer, so there are often many iterations of code tweaks, test, repeat.
The problem is that the template is affected by the code- rows and columns are added/deleted based on the sample data, etc.
So I either have to close without saving, and keep a handwritten log of the next few lines of code I've identified as requiring edits, or, I save the file but then have to go copy/paste the…
5 votes -
Language-Integrated Query (LINQ) for VBA
Language-Integrated Query (LINQ) for VBA!
1 vote -
Can't add ActiveX into Excel 2016
Unable to add new/existing ActiveX controls into Excel 2016 whether it is a brand new worksheet or an existing worksheet. Getting an "Cannot Insert Object" error. Have researched previous issues on this and there are only fixes up until Office 2013. Requiring assistance in finding a fix to this issue ASAP.
2 votes -
Ensure that updates do not corrupt VBA macros
After moving from Office 2010 to 2016 (on-prem), our users began to experience severe problems with macro-enabled workbooks (XLSM). These workbooks would not open, or open with errors, or the macros would crash Excel when run, or opening the workbook would crash Excel, or the Visual Basic Editor in Excel would exhibit weird behavior.
In all cases, the problem could be solved by opening the XLSM without active content enabled, and recompiling the VBA project. But in all cases, these were VBA projects that had worked normally before, and had been succesfully compiled before.
Recently, we rolled out an update…
7 votes -
Macros - Make it simple to transfer macros and PERSONAL workbooks, and combine multiple PERSONAL workbooks on one computer.
Macros - Make it simple to transfer macros and PERSONAL workbooks, and combine multiple PERSONAL workbooks on one computer. This is ridiculous. I use multiple complex macros. Make it easier for regular people to do!
2 votes -
Lookbacks in Regex being supported
Currently, with VBA's reference of "Microsoft VBScript Regular Expressions 5.5", lookbacks aren't supported. The only way to mimic a poor lookback is to use grouping, and have a partial lookback before the grouping. For example:
LookbackPortion(The Group we want)
While this works for some cases, it in no way comes close to being a proper implementation of a lookback.
Currently there are many requests for Regex in Excel. Currently, it's fairly doable with a short user-defined function.
So the request is to properly implement regex lookbacks in VBScripts
1 vote -
freeze panes via VBA without needing to activate the sheet
in VBA there is no way to split & freeze a sheet without Activating the sheet first.
Most tasks can be programmed to change a sheet without the sheet being Activated.
So, please provide a means to add/delete/control split & freeze panes programmatically in VBA without the need to activate the sheet first.
1 vote -
1 vote
-
More vba events
VBA events are extremely powerful but currently they are seriously lacking! If the Excel team went through and exposed more events VBA would a lot easier to manage for complex applications.
Events to expose:
* Row and column insertion
* Table specific events:
** Table - Insert_Row
** Table - Insert_Column
** Table - Cell_Change
** Table - On Filter
** Table - On Filter button click
* Chart events!
** Chart - On Mouse Down
** Chart - On chart object select
** Chart - On chart resize
* Shape events
** On shape resize
** On shape click …1 vote -
VBA error object to include line number/text property
VBA Error object should have properties called line Number and line text which will let us know the line number of the code and the line text of the code where error occurred. This will help us very much in case of offline troubleshooting through logs
3 votes -
Give option to make PERSONAL macro file AutoRecovery file automatically load instead of the original file
When excel crashes the 'PERSONAL' macro autorecovered file is listed but the original file is automatically opened too which makes saving the autosaved one a pain in the **** as it is now called PERSONAL (autorecovered) and as the original is open you can't just rename it and save. It should just auto open the autorecovered one and then just ask if you want to save as normal when you close excel. I would actually prefer this for all autorecovered files.
1 vote -
translate
please remove translator in menu key in excel, it doesn't help but rather slows the excel user is pasting and copying. please please, no disregard to its creator, but i hope this feedback will notify you. please use any other letter not S
1 vote -
when changing an addin ask to save when closing Excel
Now when I have changed an addin and close Excel the addin is not saved unless I push the button. Just like other files I want that Excel ask me if I want to save or not
1 vote -
Defining a subset of the possible VBA commands usable without triggering a security prompt
Might allowing the use of a subset of VBAs commands (enforced by the virtual machine) for certain projects allow for a reduction in the need for security prompts and help prevent users becoming accustomed to clicking enable when opening a spreadsheet without thinking of the consequences. I.e. certain spreadsheet could be tagged by the developer as only using this subset of VBA commands and could run without the need to trigger a security prompt.
1 vote -
Disabling Page Layout View From VBA
Disabling Page Layout View From VBA
Allowing the user to change this breaks frozen panes.
1 vote -
Make the keyboard shortcut Ctrl+G close the Immediate window in the VBA editor
In the VBA editor, when I press Ctrl+G to open the Immediate window I expect the Immediate window to close when I press it again.
I suggest making this keyboard shortcut works as a toggle button to open and close the Immediate window.
We currently don't have any way to close this window except pressing the exit button.
2 votes -
Allow Excel to connect to"Mail"for the "SendMail" macro command
Enable Excel to connect to "Mail" for the "SendMail" macro command.
1 vote -
Improve *Workbook.RefreshAll method
Please consider updating method RefreshAll of Workbook object by adding return value to it.
At least return 'true' when refresh went successfully, 'false' when not.
Currently, VBA ignores appearing during refresh of connections errors. However, when such refresh is triggered manually by pressing menu button (tab Data -> Refresh All), Excel shows message and a proposal to cancel refresh of remaining queries or continue.
Description of problem can be also found under following links
Thank you!
7 votes
- Don't see your idea?