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

Get Programming Excel with VBA and .NET now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.