To work around the issue, save the embedded or new workbook to a trusted location.įor more information about the Block macros from running in Office files from the Internet Group Policy setting, see New feature in Office 2016 can block macros and help prevent infection. This issue occurs if the embedded Excel workbook isn't from a trusted location, or the new workbook isn't saved to a trusted location. Macros in this document have been disabled by your enterprise administrator for security reasons. Our guide continues below with additional information on enabling Excel 365 macros, including pictures of these steps. After opening up the workbook today I came to the upsetting realization that all my macros have suddenly disappeared. In any open workbook, click Unhide on the View tab. Select your Macro security level, then click OK. Macros Disappeared in Macro-Enabled Workbook Excel 2016 I have built out and been working off of a spreadsheet for the past two weeks utilizing VBA macros in excel 2016 (Windows 10). Unhide Personal Macro Workbook: If you wish to edit a macro that is saved in the Personal Macro Workbook, you will first need to unhide it. In an environment that has the Block macros from running in Office files from the Internet Group Policy setting enabled for Microsoft Excel 2016, macros in embedded Excel workbooks are blocked from running.įor example, when you create a new Excel workbook and embed a macro-enabled workbook in the new workbook, you receive the following security notice: Microsoft Office has identified a potential security concern. When you exit Excel, you will be prompted to save changes made to the Personal Macro Workbook. For more information about this change, read this blog post.
Office 365 ProPlus is being renamed to Microsoft 365 Apps for enterprise.