What is Excel macro enabled workbook

Excel 2019 offers support for four file types. Macros are not allowed to be stored in the .xlsx file type, and this file type is the default file type! You have to use the Save As setting for all of your macro workbooks, or you can change the default file type used by Excel 2019.

The available files types are as listed here:

• Excel Workbook (.xlsx)—Files are stored as a series of XML objects and then zipped into a single file. This creates significantly smaller file sizes. It also allows other applications (even Notepad!) to edit or create Excel workbooks. Unfortunately, macros cannot be stored in files with an .xlsx extension.

• Excel Macro-Enabled Workbook (.xlsm)—This is similar to the default .xlsx format, except macros are allowed. The basic concept is that if someone has an .xlsx file, he will not need to worry about malicious macros. However, if he sees an .xlsm file, he should be concerned that there might be macros attached.

• Excel Binary Workbook (.xlsb)—This is a binary format designed to handle the larger 1-million-row grid size introduced in Excel 2007. Legacy versions of Excel stored their files in a proprietary binary format. Although binary formats might load more quickly, they are more prone to corruption, and a few lost bits can destroy a whole file. Macros are allowed in this format.

• Excel 97-2003 Workbook (.xls)—This format produces files that can be read by anyone using legacy versions of Excel. Macros are allowed in this binary format; however, when you save in this format, you lose access to any cells outside A1:IV65536. In addition, if someone opens the file in Excel 2003, she loses access to anything that used features introduced in Excel 2007 or later.

To avoid having to choose a macro-enabled workbook in the Save As dialog box, you can customize your copy of Excel to always save new files in the .xlsm format by following these steps:

1. Click the File menu and select Options.

2. In the Excel Options dialog box, select the Save category from the left navigation pane.

3. Open the Save Files In This Format drop-down menu and select Excel Macro-Enabled Workbook (*.xlsm). Click OK.

   If you open a macro-enabled workbook, a Security Warning message states that the workbook contains macros. This protects you from possible harm — some macros might contain viruses or other hazards. You can choose to enable the content if the workbook is from a trusted source.

   Save a macro-enabled workbook

   Follow these steps to save a macro-enabled workbook:

   1. Click the File tab and then choose Save As.

      The Save As dialog box appears.

   2. Enter a name and select a location for your workbook.

   3. Click the Save as Type drop-down arrow.

      A list of file types appears.

   4. Select Excel Macro-Enabled Workbook.

      Excel adds the .xlsm extension to the filename.

   5. Click Save.

   If you create a macro in a workbook and neglect to save the workbook as a macro-enabled workbook, you see a warning message telling you that the macro will not be retained.

   Recently had the same issue, found this buried in the Microsoft faqs it worked for me but my issue was because the file was being stored on one drive

   Files on OneDrive or SharePoint

   If a user downloads a file on OneDrive or SharePoint by using a web browser, the configuration of the Windows internet security zone (Control Panel > Internet Options > Security) will determine whether the browser sets Mark of the Web. For example, Microsoft Edge sets Mark of the Web on a file if it's determined to be from the Internet zone.

   If a user selects Open in Desktop App in a file opened from the OneDrive website or from a SharePoint site (including a site used by a Teams channel), then the file won't have Mark of the Web.

   If a user has the OneDrive sync client running and the sync client downloads a file, then the file won't have Mark of the Web.

   Files that are in Windows known folders (Desktop, Documents, Pictures, Screenshots, and Camera Roll), and are synced to OneDrive, don't have Mark of the Web.

   If you have a group of users, such as the Finance department, that need to use files from OneDrive or SharePoint without macros being blocked, here are some possible options:

   Have them open the file by using the Open in Desktop App option

   Have them download the file to a Trusted Location.

   Set the Windows internet security zone assignment for OneDrive or SharePoint domains to Trusted Sites. Admins can use the "Site to Zone Assignment List" policy and configure the policy to place h ttps://{your-domain-name}.sharepoint.com (for SharePoint) or h ttps://{your-domain-name}-my.sharepoint.com (for OneDrive) into the Trusted Sites zone.

   This policy is found under Windows Components\Internet Explorer\Internet Control Panel\Security Page in the Group Policy Management Console. It’s available under both Computer Configuration\Policies\Administrative Templates and User Configuration\Policies\Administrative Templates.

   SharePoint permissions and OneDrive sharing aren't changed by adding these locations to Trusted Sites. Maintaining access control is important. Anyone with permissions to add files to SharePoint could add files with active content, such as macros. Users who download files from domains in the Trusted Sites zone will bypass the default to block macros.

   What is an Excel macro workbook?

   What is a Personal Macro Workbook? A Personal Macro Workbook is a hidden workbook in your system that opens whenever you open the Excel application. Related: How to Automatically Open Specific Excel Files on Startup. It's a place where you can store macro codes and then access these macros from any workbook.

   Should I enable macros in Excel?

   Enable all macros (not recommended, potentially dangerous code can run) Click this option to allow all macros to run. Using this setting makes your computer vulnerable to potentially malicious code and is not recommended.

   Are macro

   If you want to enable macros for only specific workbooks, save them in a trusted location instead. Enabling all macros in all workbooks makes your computer vulnerable to potentially dangerous codes.

   How do I open macro

   Change macro settings in the Trust Center.

   Click the File tab..

   Click Options..

   Click Trust Center, and then click Trust Center Settings..

   In the Trust Center, click Macro Settings..

   Make the selections that you want, then click OK..