Record Macro - Record custom user actions

[Sal]

Is there a way to have Excel record custom user actions (say like a
user executing a Addin function by clicking on a custom toolbar button)
in addition to standard Excel actions during macro recording?

I know you can program VBA code that adds/deletes/edits VBA code using
VBA objects like 'VBIDE' & 'VBProject.VBComponents'.
So if not explicitly, can this be done as a 'hack' by implementing VBA
code that writes VBA code?... so during 'Record Macro' it would add my
own code to that which Excel is recording programmetically based on the
user executed custom calls that i can detect?
Thanks in advance.
Salvatore Anzalone

 

[Sal]

After further research, i realized it can in fact be done without using
'VBIDE' & 'VBProject.VBComponents'.

The built in excel VBA command is 'Application.RecordMacro([code to
record])'.

See Excel VBA help for 'Application.RecordMacro' for more info.
thankyou to me!