It would be extremely useful to me, and perhaps other developers, to have a unique read-only ID for each sheet that would *never* change. It would be assigned internally by Excel at the time the sheet was created. The idea would be for it to function as an auto-incrementing identity column does for a row in a database.

Why would this be useful? If you store sheet names anywhere in the workbook--such as in range or table--for use in VBA code *and* you allow the user to rename worksheets, your code will break as soon as the user renames a sheet.

What I have done as a workaround is either (a) resort to tracking the state of the sheet collection so I can detect a "name-changed" event or (b) use the VBA module name as the unique identifier for the sheet.

It would be much easier if each sheet had a Sheet.ID property and there was a related method on the Worksheets collection such as Worksheets.GetByID(). Then I could store Sheet.ID instead of Sheet.Name. The user would be free to change the sheet name and I would not have to worry about my code breaking.

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 with MS engineers due to its security implications

Nice day.
As there are more and more keyboard shortcuts for windows applications, there are sometimes fewer candidates to be used as keyboard shortcuts for Macros.
I've been looking at this problem since the first few releases.
That's why I'm getting more reactionary every day to use Windows Shortcuts and their apps.
As in the new versions the use of Alt is becoming popular, (press and drop)...

Propose:
Use this option of Alt, Shortcut to launch the keyboard shortcuts of macros and add-ons, that is, those that are not native to the application or Windows.

Example:
I just installed Zoomit and the fabulous combination you use to launch it is CRTL+1
I mean
that if I'm in Excel, for example, instead of opening the settings panel, i launch the Zoomit, of course that command I can change in the program but, by what?, besides many others like scrolling Crtl+Up Arrow, it is not possible to modify them.

Utility:
If Alt is implemented, Shortcut to launch Shortcuts from macros and add-ins would eliminate that conflict.

In addition:
If in settings, you add the option to toggle that behavior (True /False) people who are used to using the Shortcuts of their macros instead of the ones that come by default, they could change that option to continue using them as they come doing beforehand.

Additional Tip:
People who, because of their ACCESSIBILITY needs, have to use special commands would have access, without having conflicts with their special programs, to the classic Shortcuts.

Thank you in advance.
Greetings.

Translated from Spanish using Microsoft 5.6.0.0 Translator app

VBA Range.Replace method applies the current Within (Workbook) setting of the Find/Replace dialog box even though an explicit range of workbook.sheet.cells is provided to the method. The desire is to replace only within the scoped range, not across all sheets of a workbook. Although the VBA can be coded to first execute a benign Range.Find instruction which "magically, without the option to indicate" resets the Within property value to Sheet, the responsibility of having to do so should not be necessary. The Range.Replace method should provide for a Within parameter and stick to the range of Sheet or Workbook according to the parameter. In my opinion, Range.Replace is defective by not keeping within the explicit Range of reference and also lacking usability by not providing an optional parameter to indicate the Within scope of Sheet or Workbook. (Microsoft Office Dev Center documentation link: https://docs.microsoft.com/en-us/office/vba/api/excel.range.replace)

Macabacus is a productivity suite that really cuts down on my work time because they allow you to cycle through precedents within a formula (by using arrow keys) so that whenever you click on a precedent cell within the formula, you can choose to be taken to that reference cell automatically (any tab throughout the workbook) and continue auditing the formulas in the precedent cells.

However, I've spent hours trying to incorporate this Add-in into Excel, but I think there may be some sort of issue with the 2019 Excel Release. I'm an advanced user and just purchased Excel 2019 - Home & Office 2019, but it's not working properly. I followed each step in the troubleshooting guide, but still do not see the Macabacus productivity (e.g. beside the Acrobat tab).

The Macabacus Add-in always disappears from the COM Add-ins list whenever I close Excel. Please Remedy this - would be really, really beneficial to my productivity.

Troubleshooting Macabacus: https://macabacus.com/docs/troubleshoot/loading-and-installation

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
* Comment events
** On Comment Edited
** On Comment Removed
** On Comment Created

And so on. Currently there are extremely few VBA events (a comprehensive list can be found here: https://gist.github.com/sancarn/68003988e83581f09dbbaa85be6611bd#file-original-use-case-md)

Adding more VBA events would greatly advance our productivity, as currently to emulate all the above events we have to poll Excel, which is simply ridiculius...