How to record a Macro in Excel

Published by LakesProjects on

In this video I show you how to record macros in Excel using the ‘Record Macro’ utility on Excel’s ‘Developer’ tab – this includes showing you how to enable the ‘Developer’ tab, changing ‘Macro Settings’ and also viewing the visual basic code behind your macro. – Please skip to any part of the video you’d find most helpful:

0:20 – turn on the developer tab

1:48 – macro settings and security

3:01 – recording a macro

5:24 – view your macros visual basic code

Download link for the example Excel file used in this video:…


Thanks for watching and please like, comment and subscribe as it will help my channel to grow and hopefully help as many people as possible.

Visit my website where you can download my free spreadsheet templates:

About me:

I work in project management and I use Excel a lot. I have a website ( where I have lots of the spreadsheet templates I’ve made over the years which are free for you to download. My templates have made my life a lot easier and it seemed silly not to share. I’ve been asked a few times about tutorials and this is why I’ve started my own Youtube channel where I’ll be uploading ‘How To…’ videos regularly to hopefully help you with any Excel questions you have.


Leave a Reply

Avatar placeholder

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