Excel 2007/2010/2013 - The Developer tab

Introduction
Activate the Developer tab

Code

Visual basic
Macros
Record Macro
Use Relative References
Macro Security

Controls

Insert
Design Mode
Properties
View Code
Run Dialog

XML

Source
Map Properties
Expansion Packs
Refresh Data
Import
Export

Introduction

Few people actually develop Visual Basic for applications (VBA), macrocommands, forms or in XML. It's for that reason that the Developer tab is hidden to leave more screen space for contextual tabs that are more often used.

Excel 2007: Développeur-Introduction

Activate the Developer tab

Here is how you can activate the Developer tab.

Press the Office button. For Office 2010/2013, presse the File Tab.

From the list, select Options.

Afficher onglet développeur

From the list of categories of options, select the category Standard.
Activez the option Unhide the tab Développeur in the ribbon.
Press the OK button.

You have now a new tab that allows you to create and manage of macro-commands, insert and manage of formulaires and manage of modules XML.

Code

Visual Basic

Macros

Record Macro

Enregistrer une macro

It's from this window that you can give a name to your new macrocommand. The name must not include any spaces. Like the names that you can give to a cell, or grop of cells, , you can use an souligné ( _ or Shift + -) to connect two words.

You can also create a shortcut key to activate a macrocommand by combining the CTRL key with another catacter. But be aware that key combinations are already used and are very useful. Here is a partial list :

CTRL+A
CTRL+C
CTRL+X
CTRL+V
CTRL+F
CTRL+H
CTRL+G
CTRL+I
CTRL+J or CTRL+Q
CTRL+K
CTRL+M

Select all
Copy
Cut
Paste
Find
Remplace
Place in bold
Place in italic
Personnalized presentation
Insert a hyperlink
Place in monetary format

CTRL+N
CTRL+O
CTRL+P
CTRL+S
CTRL+T or F5
CTRL+U
CTRL+W
CTRL+Z
CTRL+0 (zéro)

New document
Open a document
Print
Save
Reach a specific cell
Underline
Close a document
Cancel the the last action
Place a thin border

Press the Use Relative References.
Select the range of cells from B3 to D3.

Select the Home tab.
Select the background color of your choice.
Also change the color of the font.
Return to the Developer tab.

Press on Stop recording.

Execute a macro-command

Place the cursor in the B10.

Press on the Macros command.

Excel 2007 - Fenbe macros

The window Macro you affiche the list of macro-commands available that you can exécuter; incluant the one that you venez of create.

From the list of macrocommands, select the one that you just created.
Press the Execute button.

Your small macro-command was executed and affected the cells B10 to E10. If you hadn't chosen the Use relative reference option, which means according to the location where the active cursor is presently located at the start of the macro recording, the macro-command would have been executed at same location where you recorded the macro.