excel2010 How to record a macro

Source: Internet
Author: User

excel2010 How do I record a macro? Everyone has in the use of excel2010 encountered do not know how to record a macro difficulty? Small make up for you to dispel doubts!

1. First open Excel2010 new worksheet.

2. On the Main Development Tools tab, in the code group, click Record Macro.

3. Pop-up "Record Macro" window, we can set the "macro name", etc., you can also use the default settings, and then click OK.

4. For example, we enter "Hao are for You" in cell C1 (when you stop typing, the button is grayed out), press ENTER.

5. Click "Stop Recording".

6. Then click the "Macros" button.

7. In the Pop-up Macros window, select "Macro 1" and click "Edit".

8. Then we can look at the code for "Macro 1" in the Visual Basic Editor.

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.