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. ![]() ![]() You 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. |