Is it possible to pause a Macro recording in Excel 2007?


  • Dear all,

    I've just started learning VBA. Currently I'm reading a chapter about Macro recording in Word and Excel (Office 2007). Whenever I record a Macro in Word it is possible to pause the recording (but not stop it definitly) in order to avoid recording several actions which are irrelevant to our Macro. Yet, I didn't find any Pause button for recorded Macros in Excel. Is there any?

    Thanks in advance
    Wednesday, November 25, 2009 9:34 PM


All replies

  • Hi 

    Stop recording button is on the developer tab. 
    but I have never seen a pause button on the way of recording in excel.
    I think you should remove unnecessary codes in person.



    the best time to plant a tree was twenty years ago. the second best time, is today (Chinese proverb) sjoo.kwak at
    Wednesday, November 25, 2009 10:44 PM
  • No, There is no Pause Option.
    Thanks Dileep
    • Marked as answer by dariyoosh Thursday, November 26, 2009 9:10 AM
    Thursday, November 26, 2009 6:52 AM
  • Dear friends,

    Thank you very much for your help.

    Kind Regards,

    Thursday, November 26, 2009 9:11 AM
  • Hi,

    Check out the RecordAtMark COM addin on Stephen Bullen's site
    Thursday, November 26, 2009 9:30 AM