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

There is a limitation to the width and height of a Content Pane at 1000 x 1000px. This limit is imposed when resizing via mouse in Excel Desktop and the JavaScript API. This (via mouse) is not true in Excel Online (or in PowerPoint) where the size can be set and saved to any size via mouse.

It would make the Content Pane consistent and open up a huge number of innovation opportunities to remove the current 1000 x 1000px limitation in the JavaScript API and Desktop Content Panes in Excel.

The ability to position and resize the Content Pane via the JavaScript API and Command Add-in would offer powerful opportunities for new applications and extending Excel functionality.

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

Here I send a Macro that was recorded on Excel from Ofice 365 with a clear text on cell "B3", an Annotation on cell "B5" old excel comment, a new Excel Comment on cell "B9" and on cell "B12" the number "1234".
If your clear "Delete" all of them on the worksheet and start the Macro that was recorded automatically by Excel we get Erro in execution Time '1004'

Sub Macro1()
'
' Macro1 Macro
'
'
Range("B3").Select
ActiveCell.FormulaR1C1 = "Teste 1"
Range("B5").Select
Range("B5").AddComment
Range("B5").Comment.Visible = True
Range("B5").Comment.Text Text:= _
"Sergio Eduardo Antonio:" & Chr(10) & "Teste de Inclus?o de Anota??o antigo ""Coment?rios""."
'Range("B9").Select
'Range("B9").AddCommentThreaded ("Testes de inclus?o do Coment?rio Novo.")
'Range("B9").CommentThreaded.AddReply ("Teste de resposta ao Coment?rio Novo.")
'Range("B9").CommentThreaded.AddReply ( _
' "Observa??o ""Esta ? resposta ao novo tipo de coment?rio dispon?vel no Excel do Ofice 365""" _
' )
Range("B12").Select
ActiveCell.FormulaR1C1 = "1234"
Range("B10").Select
End Sub

When create a custom control in contextualTab, callbacks are executed only first time then control is shown.
Because contextualTabs shows information about selected object (listObject, chart, etc), all controls MUST BE invalidate each time selected object changes in Excel.
Workaround its invalidate ALL CONTROLS from ALL CONTEXTUALTABS in Application_SheetSelectionChange() and Application_SheetActivate().
This is a LOT of code executions (each seleccion in Excel executes .InvalidateControl to all controls in all ContextualTabs).

But... if exists onShow="callback" triggered when ContextualTabs shows information it runs faster.

Or even better, when Excel shows a ContextualTab, all inner-custom controls must be automatically invalidate, then all of them will 'reload' information about selected object.

Thanks