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

    Question

  • 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
    Dariyoosh
    Wednesday, November 25, 2009 9:34 PM

Answers

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.

    HTH

    SJOO

    the best time to plant a tree was twenty years ago. the second best time, is today (Chinese proverb) sjoo.kwak at gmail.com
    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,

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

    Check out the RecordAtMark COM addin on Stephen Bullen's site
    http://www.oaltd.co.uk/Excel/Default.htm
    Cheers www.andypope.info
    Thursday, November 26, 2009 9:30 AM