![]() ![]() Note that at the left of the Trust Center dialog box there is a Trusted Locations option. The first is that you can store your macro-enabled workbook (the one you want to open without the message) in what is called a trusted location. ![]() It is possible to choose a more permissive security level in the Trust Center, but Raymond specifically said he did not want to do that. (Were it not so, Raymond would not see an "enable macros?" notification when opening the workbook.) ![]() I generally suggest that the second option (Disable All Macros with Notification) be the security level used, and I suspect that this is the same level that Raymond has selected. ENABLE PERSONAL MACRO WORKBOOK EXCEL 2016 CODEYou can see the Trust Center by displaying the Developer tab of the ribbon and, in the Code group, clicking the Macro Security tool. The "enable macros?" message you see when you open a macro-enabled workbook is generated by Excel based on the settings you've made in the Trust Center. He doesn't want all workbooks to be automatically enabled, just these particular workbooks. He wonders if there is a way to always open these particular workbooks with enabled macros. It is a real pain for him to enable the macros to run when he opens the workbooks, and sometimes he hits the wrong button and doesn't get the macros enabled. Raymond has a small number of Excel workbooks that he works with every month, and these workbooks include macros. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |