Posted to microsoft.public.excel.misc
|
|
Macro recording doesn't appear to function?
Thanks for the confirmation, that's what I was guessing. Cheers
"Bob Phillips" wrote:
The macro recorder won't record what is happening in John's add-in, just
what you do in Excel.
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"Bullseye" wrote in message
...
I used to use the Record Macro dialog to build a reasonable macro in Excel
95
years ago, then use the VB interface to fine tune. Now in Excel 2003 when
I
use the same Record Macro interface, finish and go to the VB
interface...my
macro name is there, but none of the keystrokes I input is recorded. What
am
I doing wrong?? I am sure it is me, but I am selecting different
worksheets,
selecting cells, then going to an Excel add-in (JWalk charting for
example),
updating the series reference, then stop record. At least some of this
should record right? Here is the code it give me:
Sub CHART_LABEL_UPDATER()
'
' CHART_LABEL_UPDATER Macro
' Macro recorded 2/28/2007
'
'
Sheets("Schedule Plotter").Select
End Sub
Any thoughts? Thanks in advance
|