Please remember to mark the replies as answers if they help and unmark them if they provide no help. 3 hours ago &0183 &32 Microsoft Excel macros are designed to automate tasks you perform Excel will not run macros by default, so youll have to explicitly change some 0 Microsoft will disable XLM macros in Microsoft 365 to prevent users from With more people working from home than ever before last year, VBA will not work on excel online, since it was. MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft ![]() ![]() I hope these can help you and feel free to follow up if I have missed something. In addition, here are the articles about the settings of Macro Security in Excel for you to reference: VBA for Excel Lesson 10: VBA Macros Security and Protection in Excel It is designed by Office, the only way is to set the security via Options button in the ribbon. Seems that there doesn't exist the code to control the security dialog. If I have misunderstood you, please let me know.Īs for this issue, I think it is not possible to achieve this, because if your Macro is disabled when opening Excel, the VBA code will not be executed and it ![]() Thank you for posting and we are glad to help with you.Īfter reading your post, I know that you want to control the Security Alert Dialog whether to be opened via VBA code.
0 Comments
Leave a Reply. |