how to Open Macro-Enabled Workbooks
"How to Open Macro-Enabled Workbooks"
The Macro-enabled Workbooks
Macro-enabled workbooks are way cooler than the normal workbook you have. With this feature enabled, you can do a lot of things from programming to automation. So, before you can enjoy the best of the benefits of macro-enabled workbooks, you should set your Microsoft Excel first.
Our Workbook works best in Microsoft Office 2016 and up so you'll need to get information about the excel version first.
Macro-enabled workbooks have dot-xlsm (.xlsm) filename. So, at first glance, it is easily distinguished. If you cant see that .xlsm on the file name, right-click the file and view its properties. (See the photo as your reference).
You should be aware that some hackers put viruses in macro-enabled workbooks to infect PC's and steal data from the users. It is of utmost importance that you knew where the workbook came from and it is from a valid source.
The image below summarizes all the process.
This will be divided into two (2) parts: *Part 1 is how to show the developer option to the customized ribbon *Part 2 is how to enable macros
#1 Open a new excel file. On your upper left corner, click the "FILE"
#2 You will see lists of options. Click the "OPTIONS"
#3 Under the Options, click the "Customized Ribbon" Ribbon are the menu found in on the upper part of the Excel.
#4 You will see 2 boxes. In the right box, you can either check or uncheck any list. Check the "DEVELOPER" and then click the "OK" button.
#5 Once the Developer Option has been checked, you will see the "DEVELOPER" in the Ribbon. Click it
#6 On the upper left, you will see some options including Virtual Basic, Macros, Record Macro etc. Find "MACRO SECURITY" and click it. It usually has a DANGER SIGN ICON on it.
#7 Find and Click "MACRO SETTINGS"
#8 And check "ENABLE ALL MACROS" then click "OKAY"
Close all opened Excel workbooks.
At this point, you can now open any macro-enabled workbooks.
If you are into Safety, Health, or Human Resource, I have a macro-enabled workbook that could help you with your recording needs. :D
Marcelo III Saplagio, RN is the Founder and Creator of ExcelinSafety, an advocate to safety and health. He spends time in research and development of the tools and templates that will simplify the work of HSE Professionals in data recording and documentation. ExcelinSafety Workbook has helped thousands of Safety Professionals, moreover, thousands of Safety Officers, OH Nurses and HR Officers downloaded the TEMPLATES that he offered for free. According to him, this is his "CONTRIBUTION TO PROFESSION".
He has five (5) years experience in OSH and currently working as Safety Officer III in Ridge To Reef Builders and Supply Corporation.