| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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?  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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Record Macro and Edit Macro options disabled | New Users to Excel | |||
| What does it mean to record the macro | Excel Discussion (Misc queries) | |||
| Record New Macro | Setting up and Configuration of Excel | |||
| Record Macro - Record custom user actions | Excel Programming | |||
| how to count/sum by function/macro to get the number of record to do copy/paste in macro | Excel Programming | |||
![T-®ex[_69_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
