Results 1 to 3 of 3

Thread: Record a Macro in MS Excel

  1. #1
    Join Date
    Aug 2006
    Posts
    181

    Record a Macro in MS Excel

    Hi,
    Macros are advanced features that can speed up editing or formatting you may perform often in an Excel worksheet. They record sequences of menu selections that you choose so that a series of actions can be completed in one step. but i dont know how to record them. please help me.

    Thank you
    QTechnology Ultra-Quiet ATX PSU 460W I MSI K8N Neo4-F I AMD Opteron 144 CABNE0545 2.66Ghz I 2 x 512MB RAM I 380GB Maxtor SATAI Raid0 Hard Drive I 40GB Maxtor IDE Hard Drive I Nvidia GeForce 7900GTX I Win XP Home Service Pack 2 I Soundblaster Xtreme Fidelity Fatal1ty I Mercury Home Theater HT-4500

  2. #2
    Join Date
    Sep 2005
    Posts
    1,306

    Re: Record a Macro in MS Excel 2007

    Recording a Macro

    To record a Macro:

    • Click the View tab on the Ribbon
    • Click Macros
    • Click Record Macro
    • Enter a name (without spaces)
    • Enter a Shortcut Key
    • Enter a Description
    • Perform the Macro
    • Click Marcos
    • Click Stop Recording
    • Stop Recording Macro Button

  3. #3
    Join Date
    May 2008
    Posts
    4,345

    Re: Record a Macro in MS Excel 2007

    Here's how to record a macro to apply these formats:

    1. In the workbook where you track your accounts receivable, click one of the cells you're going to format.
    2. Point to Macro on the Tools menu, and then click Record New Macro.
    3. In the Record Macro dialog box, type a name for the macro in the Macro name box. Macro names must start with a letter and can include letters, numbers, and underscore characters, but can't include spaces. You don't need to change the other boxes:

    When you click OK, the Stop Recording toolbar appears, and you're ready to record. Until you stop the recording, every Excel command and keystroke will be recorded in the macro, in the order in which they are entered.

    4. Now format the cell the way your boss wants it flagged: click Cells on the Format menu, click the Font tab, click Bold under Font style, click Red for Color, click the Border tab, click Red for Color, click the border thickness you want, click Outline, and then click OK.

    5.To finish recording the macro, click the Stop Recording button:

Similar Threads

  1. Excel 2003 Macro doesn't work in Excel 2007
    By jjaw in forum Windows Software
    Replies: 3
    Last Post: 03-01-2014, 03:28 PM
  2. How to use Excel Macro
    By aSITA in forum Windows Software
    Replies: 5
    Last Post: 12-02-2011, 10:34 PM
  3. How to Write Macro in Excel using VBA
    By Trog in forum Guides & Tutorials
    Replies: 3
    Last Post: 10-02-2011, 07:25 PM
  4. What is a Macro that is used in MS Excel?
    By Common in forum Windows Software
    Replies: 5
    Last Post: 19-03-2010, 02:08 AM
  5. Macros enabled but record macro is grayed out
    By Rail racer in forum Windows Software
    Replies: 4
    Last Post: 29-01-2010, 12:34 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,642,466,895.43401 seconds with 17 queries