So assume that I want to apply following formattings. When I found numbers like 3.14159265359, 1.4121356 having lot of decimal digits in Excel cells I want to apply few formattings to look them cleaner and more readable. Alternatively, we can write macros with visual basic for application code on Excel.

The easiest method to create a macro in excel is to use the “Record Macro” feature. 'If your enterprise does not have any workflows that involve the use of macros, disable them completely.You can easily create a macro in excel by using Excel Macro Recorder or by writing macros with visual basic for applications code on excel. 'For enterprise administrators, turn on mitigations in Office that can help shield you from macro-based threats, including this new macro-blocking feature,' they added. 'For end-users, we always recommend that you don’t enable macros on documents you receive from a source you do not trust or know, and be careful even with macros in attachments from people you do trust - in case they’ve been hacked,' researchers from the Microsoft Malware Protection Center said in a blog post. When the setting is enabled, a user who attempts to open a document that contains macros will see a blocked content warning: 'Macros in this document have been disabled by your enterprise administrator for security reasons.' The user won't have an option to manually bypass the restriction. It can be configured for each Office application.

The new setting is called, 'block macros from running in Office files from the Internet' and can be found in the group policy management editor under User configuration > Administrative templates > Microsoft Word 2016 > Word options > Security > Trust Center.

This includes files downloaded from any Internet websites, including cloud storage providers like Microsoft OneDrive, Google Drive and Dropbox documents attached to emails received from addresses outside the organization and documents downloaded from file-sharing sites.

That's why Microsoft has now come up with a better solution: a group policy setting that administrators can use to disable macros only for Office files obtained from locations that Windows considers part of the Internet zone.

Disable macros in excel 2016