The following code saves the selected sheets as a single PDF. This section contains the base code to save Excel as PDF from different objects (workbooks, worksheets, ranges, and charts). From a VBA perspective, it is the ExportAsFilxedFormat method combined with the Type property set to xlTypePDF that creates a PDF. Saving Excel workbooks, sheets, charts, and ranges as PDF
Other fixed formats available (xlTypeXPS). VBA Save to PDF Example using all the options. Selecting specific worksheets before saving as PDF. Saving Excel workbooks, sheets, charts, and ranges as PDF. I reinstalled Office 2016 from the portal and still the problem occurs. 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.
0 kommentar(er)
