Take a Guess to Win Windows 10 Pro Key!
previous arrow
next arrow
Slider

The Excel Developer Tutorial

Date:2020-10-26 Author:Sandra

We need to use various commands included in the developer tool. By default, the developer tool option is hidden, you may need to manually enable it. After enabling it for the first time, this tab will be displayed by itself every time you open a file.

Enable Developer

The Excel Developer Tutorial

We just need to right-click on a blank place in the taskbar, and then click[Customize the Ribbon].

The Excel Developer Tutorial
The Excel Developer Tutorial

In the pop-up window, we check the box in front of the Developer.

The Excel Developer Tutorial
The Excel Developer Tutorial
The Excel Developer Tutorial

About Developer

The Developer tool tab contains three groups of commands, among which the commands of the code group are the most frequently used commands.

Let’s briefly talk about the function of the code group command.

The Excel Developer Tutorial

Visual Basic: Click it to open the VBA editor, the shortcut key is Alt + F11. We mentioned it in the previous article.

Macros: Open the macro list, and edit the macros in the list, such as Run, Step Into, Delete, etc.

The Excel Developer Tutorial

Record Macro: Operate with keyboard and mouse, it can be converted into VBA code automatically. This feature is very useful in the actual development process.

Use Relative Reference: This is the setting option when recording a macro

Macro Security: This can set how Excel treats workbooks that contain VBA code. Usually, we generally set the macro security to be disabled.

The Excel Developer Tutorial

More about Excel

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *