Intermediate level · Module 5: Automating Excel · Lesson 3 of 3
Office Scripts and Macro Security
Understand modern automation with Office Scripts and keep macros safe.
In this lesson you will
- Describe Office Scripts and when to use them
- Apply safe practices for macro-enabled files
Key concepts
Office Scriptsautomation in the cloudTrust Centermalicious macros
The lesson
Office Scripts automate Excel on the web using TypeScript and can be scheduled or connected to other services in Microsoft 365. VBA remains common in desktop Excel.
Macros can run harmful code. Keep macros disabled by default, enable them only for files from trusted sources and never open macro files from unexpected emails.
Document what each automation does, test it on copies and keep a manual procedure in case it fails.
Step by step
- Review the Trust Center macro settings.
- Discuss a real macro malware example.
- Explore an Office Script if accounts allow.
- Document the automation built in this module.
Practice activity
Write the automation documentation and safety note for the reporting system.
Expected result: Clear documentation and a safety note users can follow.
Check your understanding
-
Should macros be enabled for files from unknown senders?
Show answer
No.
-
Where do Office Scripts run?
Show answer
In Excel on the web, as part of Microsoft 365.
Taught live by an instructor — online or in person. Free course lessons are for self-study and do not lead to a certificate — see registration options.