Learn The Steps And Know How Macros Work In Excel

Asked By 0 points N/A Posted on -
qa-featured

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.

SHARE
Answered By 0 points N/A #114196

Learn The Steps And Know How Macros Work In Excel

qa-featured

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.

Related Questions