microsoft visual basic for applications automation error

This has worked fine for the last 3 months, day-in and day-out.

So I have auto-calc set to manual, and the following code in the worksheet: Private Sub Worksheet_Activate() I regularly have workbooks open that have too many calculations in the for me to have auto-calculation on. I reinstalled Office 2016 from the portal and still the problem occurs.I have a worksheet named 'Dates' (object name is A_Dates) that needs to be calculated when it is activated (It may be worth noting that this is in my Personal macro workbook). I also tried to completely delete Office using this link: This file is now trusted security prompts will no longer appear unless the file is opened on another computer. Editing functions are restored and the active content, including macros, will run. If the file opens in Protected View, click Enable Editing, and then clickĮnable Content. If you know that the macro comes from a source that you trust, you can change your macro security settings to allow you to enable the macro. This error usually occurs because of macro security settings. When this software was installed, you (or your administrator)Ĭhose not to install support for macros or controls.' Yes when I open Word and try to create a macro it gives me an error starting with: 'The function you are attempting to run contains macros or content that require macro language support. If you have feedback for TechNet Support, using Office 365 small business. Mark the reply as an answer if you find it is helpful. Reply with the result and I¡¯ll be glad to further assist you. Non-Microsoft registry cleaners and system maintenance applications deleted multiple registry key values that are used for VBA functionality in Microsoft Office applications. 'The function you are attempting to run contains macros or content that requires macro language support' Then, since you are using C2R version Office and if you get the error like this: Please make sure we have enabled the macros settings in Office 2016: Go to File=>Options=>Trust Center=> Enable all the macros. Did you install the Office 365 from portal?Īs far as I know, the VBA is built into many Microsoft applications (including Office 2016) and no specific download.Regarding of the issue, please provide us more information to assist you better.

Microsoft visual basic for applications automation error