Excel 2010 / Excel 2013 / Excel 2016 - Trust Center dialog box - select the Disable all macros with notification option 2. Follow the three steps above, then open the xlsm file.įig 1. Note: You should close the xlsm workbook before these changes are made. Notification means that the Warning shown in figures 2, 3,5 or 6 will appear when the macro workbook is opened From the Trust Center dialog box, select Macro Settings, then choose the Disable all macros with notification option. ![]() to display the Trust Center dialog box as shown in figure 1 On the ribbon select File > Options > Trust Center > Trust Center Settings.To check or change the Trust Center settings (in Excel 2010, Excel 2013, or Excel 2016): ![]() Laptops will only need to be set once, as the settings remain on the machine from session to session. The FBE desktop computers reset after each session, so this Macro Settings procedure will need to be performed at the commencement of each new session. ![]() Excel Windows - Macro security and the Trust Center Warning: You should only enable a macro workbook from a trusted source.ġ.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |