Learn The Steps And Know How Macros Work In Excel

Asked By Vic Toledo 0 points N/A Posted on - 07/30/2016

Hi. I have recently started working with MS Excel. What are the steps which need to be followed so as to know how macros work in Excel? Please reply ASAP. Thanks in advance.

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

• Answer Accepted: No
• Question Category: MS Excel

Answered By vobMaibia 0 points N/A #114196

Learn The Steps And Know How Macros Work In Excel

Hi. To know how macros work in Excel, follow the steps as given below-

1) Close all the windows which have been open in the visual basic editor to start working with the blank screen

2) Click on the view menu, and select the project explorer option

3) Bring the cursor to the place where there is a line separating the project view and the gray rectangle

4) Click on view menu and then click on properties window option

5) Bring the cursor to the place where there is a line separating the project view and the gray rectangle

6) Double-click on the name of the cell to add the code

7) Close it in Excel and then launch it again. You will find the VBE setup is intact.

Hope we helped.

About vobMaibia

Questions
0

Answers
1

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 07/30/2016
• Question Category: MS Excel