View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Bullseye Bullseye is offline
external usenet poster
 
Posts: 7
Default 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