Programming Excel with VBA and .NET

Name

Application.RecordMacro([BasicCode], [XlmCode])

Synopsis

Sets the code for Excel to record if the user selects Tools → Macro → Record New Macro and then performs a task that runs this macro.

Argument	Setting
BasicCode	The string to record in place of the default
XlmCode	Obsolete

By default, Excel records Application.Run " workbook ! macro " whenever a user runs a macro while recording. To prevent recording, set BasicCode to "" for the macro:

Sub SecretMacro(  )
    ' Don't record this!
    Application.RecordMacro ""
    ' Secret stuff...
End Sub