Set up: course files, Developer tab and a macro-ready Excel

The business scenario

Before Pine Valley's sales manager can run her first macro, Excel has to be ready: the Developer tab is hidden by default, macros are blocked in files from the internet, and a normal .xlsx file throws code away when you save. We fix all of that once, safely.

What you will be able to do

Unzip the course files to C:VBA Course, show the Developer tab, set safe macro security, trust only the course folder and save macro workbooks as .xlsm - in about 10 minutes.

In this video

• Unzip the course files to C:VBA Course
• Show the Developer tab
• Macro security: Disable VBA macros with notification
• Trust only the course folder
• Save as .xlsm
• Why AI tools cannot run your macros

Common mistakes to avoid

• Choosing 'Enable all macros' to make the yellow bar go away - it removes your protection for every file.
• Saving a workbook with code as .xlsx - Excel removes the code. Always save as .xlsm.
• Trusting the Downloads or Documents folder - trust only C:VBA Course.