none
How to record a macro in Microsoft project 2010 (standard and professional both)? RRS feed

  • Question

  • How to record a macro in Microsoft project 2010 (standard and professional both)?
    Wednesday, September 28, 2011 1:51 AM

Answers

  • Ankit --

    In both the Standard and Professional version of Microsoft Project 2010, do the following:

    1.  Click the View tab to display the View ribbon.
    2.  In the Macros section of the View ribbon, click the Macros pick list button and select the Record Macro item.
    3.  In the Record Macro dialog, enter a name for the macro in the Macro Name field and do not use any spaces in the name.
    4.  Click the Store Macro In pick list and choose the location in which you want to save the recorded macro.
    5.  In the Description field, enter an optional description.
    6.  Click the OK button.
    7.  Perform the actions you want to record in the macro.
    8.  Click the Macros pick list button and select the Stop Recording item.

    Hope this helps.


    Dale A. Howard [MVP]
    VP of Educational Services
    msProjectExperts
    http://www.msprojectexperts.com
    http://www.projectserverexperts.com
    "We write the books on Project Server"

    Wednesday, September 28, 2011 1:58 AM
    Moderator

All replies

  • Ankit --

    In both the Standard and Professional version of Microsoft Project 2010, do the following:

    1.  Click the View tab to display the View ribbon.
    2.  In the Macros section of the View ribbon, click the Macros pick list button and select the Record Macro item.
    3.  In the Record Macro dialog, enter a name for the macro in the Macro Name field and do not use any spaces in the name.
    4.  Click the Store Macro In pick list and choose the location in which you want to save the recorded macro.
    5.  In the Description field, enter an optional description.
    6.  Click the OK button.
    7.  Perform the actions you want to record in the macro.
    8.  Click the Macros pick list button and select the Stop Recording item.

    Hope this helps.


    Dale A. Howard [MVP]
    VP of Educational Services
    msProjectExperts
    http://www.msprojectexperts.com
    http://www.projectserverexperts.com
    "We write the books on Project Server"

    Wednesday, September 28, 2011 1:58 AM
    Moderator
  • Thank you so much Dale !! I will wll mark it as answer once the user confirms it.
    Wednesday, September 28, 2011 2:01 AM
  • A shortcut for this is to right click teh status bar (bottom of the screen) and from the list of options select macro recording. This adds a small button on the left side of teh status bar. Click to show the record macro dialog, click once recording to stop recording.

    Same instructions I think for Excel and Word.


    Rod Gill

    The one and only Project VBA Book Rod Gill Project Management
    Wednesday, September 28, 2011 7:18 AM
    Moderator