Record a Macro through VBA
 

How do you start recording a macro through VBA?

I tried *Application.RecordMacro BasicCode:="Application.Ru
""WhatsHappening"" "*...
Put it in an activate event in a worksheet... doesn't seem to work...
:

--
T-®e
-----------------------------------------------------------------------
T-®ex's Profile: http://www.excelforum.com/member.php...fo&userid=2657
View this thread: http://www.excelforum.com/showthread.php?threadid=46617

Record a Macro through VBA
 

Hmmm....

I browsed through the VBA Help... This is what I found about
RecorMacro...

'Records code *if macro recorder is on*.'

So, you can't use RecordMacro to *start* recording a macro? :eek: So,
how do you start recording a macro in VBA?

Anyone???


--
T-®ex
------------------------------------------------------------------------
T-®ex's Profile: http://www.excelforum.com/member.php...o&userid=26572
View this thread: http://www.excelforum.com/showthread...hreadid=466172

Record a Macro through VBA
 

I'm sorry. But personally I have no idea. Why would you want to do this
anyway?


--
Daminc
------------------------------------------------------------------------
Daminc's Profile: http://www.excelforum.com/member.php...o&userid=27074
View this thread: http://www.excelforum.com/showthread...hreadid=466172

Record a Macro through VBA
 

Hi T-®ex,

How do you start recording a macro through VBA?

You can't, sorry. The "Record macro" menu item is disabled when VBA is
running.

Regards

Stephen Bullen
Microsoft MVP - Excel

Professional Excel Development
The most advanced Excel VBA book available
www.oaltd.co.uk/ProExcelDev