How to Design a Simple Macro in Microsoft Excel

Asked By Amy G Thomson 20 points N/A Posted on - 11/17/2014

I want to automate certain computations in Microsoft Excel but I do not know how to go about it. I have read a few guidelines but they have not worked to date. I would like someone with experience and expertise in writing macros for Microsoft Excel to help me with some short steps to write a macro and run it successfully in Excel.

• Status: Open
• Question Views: 793
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By Jackly Donse 0 points N/A #190865

How to Design a Simple Macro in Microsoft Excel

Hi.

How are you? 

Here is one way for 2007:

 

1. Click the Developer tab on the Ribbon right at the top of the window screen.

2. Alter the security settings. it IS In Trust Centre, Under THE Macro Settings, click Enable All Macros, then click OK

3. Click the "Record Macro".

4. Give it a name for your macro. Remember that the first character of the name must be a letter.

5. Choose the location on your computer to store your macro.

6. Give your macro a little bit of description.

7. Finally Click OK to start recording your macro.

8. Do what you want the macro to record

9. Then go to developers' option, then chose code and stop recording.

About Jackly Donse

Questions
0

Answers
37

Best Answers
6

• Vote Up 0 Vote Down

• Posted on - 11/25/2014
• Question Category: MS Excel