Creating Simple Macros using MS Excel 2007

[OpenCast Excel Tips]

you frequently need to format individual cells in a particular way
(for example, currency style in red Arial bold 12-point font), a
simple recorded macro will do the trick. Use the following steps to
create it:

1. Select Tools, Macro, Record New Macro to display the Record
Macro dialog box.
2. In the Record Macro dialog box, type a descriptive Macro name
(such as "RedCurrency"). By default, the macro will be stored and
available only in the current workbook; if appropriate, open the Store
macro in drop-down list and select either New Workbook (to store and
use the macro only in a new empty workbook) or Personal Macro Workbook
(to make the macro available in all workbooks). If desired, edit the
text in Description. When done, click the OK button to begin
recording.
3. The word "Recording" will appear on the status bar at the bottom
of the Excel window to remind you that all keystrokes and mouse
actions are now being recorded. Depending on how your system is
configured, a Stop Recording toolbar may also appear in the window. If
you make a mistake, simply correct it as you normally would and
continue; both the mistake and its correction will become part of the
macro, and may be edited out later if desired.
4. Perform the actions necessary to complete the task. For this
example, the actions are:
1. Select Format, Cells to display the Format Cells dialog
box, click the Number tab, select Currency in the Category list, and
click the OK button; as an alternative, you may simply click the $
button on the Formatting toolbar.
2. Select Format, Cells to display the Format Cells dialog
box, click the Font tab and then:
1. open the Color drop-down list and select the desired
color;
2. select Arial from the Font list;
3. select Bold from the Font style list;
4. select 12 from the Size list; and
5. click the OK button.
5. If the Stop Recording toolbar is visible, click its Stop
Recording button; if the toolbar is not visible, select Tools, Macro,
Stop Recording.

[Julius Augustine Odhiambo]

Thanks

[jmwe...@technology.ucu.ac.ug]

Thx for the tip.

[Stephen M.Daniel]

Great!!!!!!!!!!!!!!!!!!

 

Regards,

---

Stephen M Daniel
Scada/ems project design manager

Urban & Rural engineering services limited.
Cell:  255 754 760326/655 760326; skype: stephen.daniel2008

---

From: Julius Augustine Odhiambo <augustine...@gmail.com>
To: microsoft-...@googlegroups.com
Sent: Wed, October 6, 2010 12:25:23 PM
Subject: Re: Creating Simple Macros using MS Excel 2007

[Rebecca Nasirumbi]

Good afternoon Sebbo, you sent me mail of appreciation but i cant remember what it was kindly remind me. Thanks any way for the blank mail it shows u care. Good day.

---

From: "jmwe...@technology.ucu.ac.ug" <jmwe...@technology.ucu.ac.ug>
To: microsoft-...@googlegroups.com
Sent: Wed, October 6, 2010 12:55:54 PM
Subject: Re: Appreciated

Thx for the tip.

[Value Based]

What do i have to do with these? --- On Wed, 10/6/10, jmwe...@technology.ucu.ac.ug <jmwe...@technology.ucu.ac.ug> wrote: From: jmwe...@technology.ucu.ac.ug <jmwe...@technology.ucu.ac.ug> Subject: Re: Appreciated To: microsoft-...@googlegroups.com Date: Wednesday, October 6, 2010, 9:55 AM Thx for the tip.

[adam kasaine]

Why am I getting it too….

The information contained in this email and any attachments is confidential and may be subject to copyright or other intellectual property protection. If you are not the intended recipient, you are not authorized to use or disclose this information, and we request that you notify us by reply mail or telephone and delete the original message from your mail system.

 

--------------
K-Rep Bank Headquarters is at K-Rep Centre, Wood Avenue off Argwings Kodhek Rd, Kilimani. To contact us call either; tel: 3906000 or 0711 058 000.
K-Rep Bank is a different kind of bank. The bank for you.

The information contained in this email and any attachments is confidential and may be subject to copyright or other intellectual property protection. If you are not the intended recipient, you are not authorized to use or disclose this information, and we request that you notify us by reply mail or telephone and delete the original message from your mail system.

The information contained in this email and any attachments is confidential and may be subject to copyright or other intellectual property protection. If you are not the intended recipient, you are not authorized to use or disclose this information, and we request that you notify us by reply mail or telephone and delete the original message from your mail system.