Excel macros and VBA for beginners: record, edit and write

Learn to automate Excel with macros and VBA: record macros, add buttons, protect input cells, edit and debug code, and write your own macro.
All Good Tutorials publishes step-by-step video courses for the software you use at work: Microsoft Office, Google Workspace and more.
Start free or try All Access free for 7 days: https://allgoodtutorials.com/supporters/pricing
What you will learn:
Record macros with relative or absolute references and run them with shortcuts
Automate real tasks: phone number formats, hidden birth years, masked ID numbers
Turn sort and filter macros into buttons anyone can click
Protect a sheet so only input cells can be edited
Read, edit and debug VBA code with Step Into and breakpoints
Write a macro from scratch in a new module
Chapters:
00:00 Course intro
01:08 What macros and VBA are
07:10 Macro safety basics
08:24 Enable the Developer tab
11:06 Developer tab tour
15:24 Macro security settings
16:35 Add-ins and controls
19:53 Record your first macro
27:50 Run a recorded macro
28:57 Relative vs absolute recording
30:37 Macro for UK phone numbers
37:17 Macro to hide birth years
41:06 Mask Social Security numbers
53:04 Sort macros
58:31 Turn macros into buttons
1:02:38 Filter macros
1:08:55 Protect input cells automatically
1:16:42 Tour of the VBA editor
1:23:31 Recorded macros in VBA
1:30:42 Edit a recorded macro
1:36:18 Debug with Step Into
1:40:39 Breakpoints
1:43:17 Read a macro line by line
1:52:06 Write a macro from scratch
2:02:49 Course recap
The project files are on the course page, included with All Access (7-day free trial) or with the course ($19).
All Good Tutorials publishes step-by-step video courses for the software you use at work: Microsoft Office, Google Workspace and more.
Start free or try All Access free for 7 days: https://allgoodtutorials.com/supporters/pricing
#Excel #ExcelVBA #ExcelMacros
