I purchased the VBA course, but I can't use the files provided as Office 365 is automatically block macros. How do I unblock in Office 365 in 2022?
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Unblock Macros
0
Discussion
Hi Maureen, I just sent a reply to your email with a link to the page that shows you multiple ways to enable the macros - depending how the macros were disabled, that changes how you enable them. Here is also the link to enable macros in Excel.
don (rep: 1989) Apr 28, '22 at 9:25 am
Answers
0
Hi Maureen and welcome to the Forum
Unless your corporate IT security has set a policy to prevent it, you should be able to click File (in Excel's ribbon) / Options (at bottom) / Trust Center / Trust Center Settings / Macro Settings / choose "Enable VBA macros..." option (noting the warning).
Even then you may need to make the source of some .xlsm files a "Trusted Location" so they open macros-enabled.
Note that if you have questions on the VBA course contents, please don't post them (or code/ files) here or elsewhere. Instead use the Contact link (in the green bar above) and use the Premium Courses option. Don will then answer you directly but allow him some time- he's a busy man!
Hope this helps.