The macros in this project are disabled что делать excel
Previously posted on «answers.microsoft.com»
The folllowing has been added to Trusted Locations \\Dcpp006\MaintenanceSvcs\PROC\Projects\Word14\Template\ Also the «Allow Trusted Locations on my network. » has been enabled.
It is my understanding that any templates placed in a Trusted Location should not generate this error.
Under «Macro Settings», «Disable all macros with notification» is selected.
The intent is to only enable macros from sources that are located in one of the «Trusted Locations.»
If I select «Enable all macros (not recommmended. «, aren’t macros from all sources enabled?
that utilize my templates. All of these users are on the same network.
In Word 2003, the templates are placed in the «Workgroup templates» location which is a Read-Only except for Admins.
Based upon the reading I have done, adding a network folder in ‘Trusted Locations’ and
FWIW, another «solution» says to add a location. The window kept telling me that the location I had selected was already added, till I realized I wasn’t supposed to select from the list before clicking «add location,» I was supposed to click Browse, and (I suppose) navigate to the folder containing the document(s) I want to run the macro on, THEN click Add Location. It’s like the New Englander who tells you how to get to the gas station by directing you to the edge of town, assuming that everyone knows how to find the station from there. Microsoft, that’s either naive, mean or lazy.
On the other hand, I did that. Nothing changed.
I know this is an old post, but I’m going to add this anyway in case someone else finds this thread.
You have to «trust the publisher.»
2. Go to File > Info.
3. You should see a Security Warning. Click the Enable Content button and then select Advanced Options.
4. The Microsoft Office Security Options dialog box appears. Select «Trust all documents from this publisher» and click OK.
Now when you open Word again, you shouldn’t get that macro warning.
Макрос — это тип компьютерных вирусов, которые могут храниться в макросах в файле Microsoft Office (например, в документе, презентации, книге или шаблоне) либо в любом ActiveX, надстройке COM илиOffice. Макросы, элементы ActiveX и надстройки называются активным содержимым.
В вашейOffice не будет автоматически запускаться активное содержимое, если файл не помечен как надежный документ или не открыт из надежного расположения.
Дополнительные сведения о надежных документах см. в документе Надежные документы.
Дополнительные сведения о надежных расположениях см. в сведениях Добавление, удаление и изменение надежного расположения.
Для всех других файлов, содержащих макрос или другое активное содержимое, обычно вы увидите сообщение, которое выглядит так:
Не выбирайте включить содержимое, если вы не уверены, что знаете точно, что делает активное содержимое, даже если файл, кажется, был от человека или организации, которые вы доверяете.
Примечание: Открытие файла с отключенными макросами может ограничить его ожидаемую функциональность.
Office сканировать файлы или расположения для поиска и удаления вирусов макроса, однако все современные антивирусные программы, такие как антивирусная программа в Microsoft Defender, должны иметь возможность обнаруживать и блокировать известные макро вирусы.
The macros in this project are disabled что делать excel
This forum has migrated to Microsoft Q&A. Visit Microsoft Q&A to post new questions.
Asked by:
Question
The following error occurs when creating a PDF file using a document that was created from a MS Word 2007 templates.
«Macros in this project are disabled. «
Has this happened to anyone else? There is no coding within th etemplates regartding PDFs. We are uding both Adobe Professional X as well as PDF Nuance.
All replies
Thanks for posting in the MSDN Forum.
Would you please provide your code snippet for further research?
Tom Xu [MSFT] MSDN Community Support | Feedback to us
There are 11 templates. I’ve included code from one (1).
(1) The user creates a Word 2007 doument based on a template. The document is saved to a location. It now has a *.docx extension.
(2) Go to the Adobe tab and click ‘Create PDF’. It creates the file, but also gives the error.
(3) The error does not happen if we use Word 2007 native Create PDF or XPS. So, I do not know why this is not working now.
One thing I just noticed, our templates get the follwoing message when we go to save as a PDF using Adobe:
Acrobat PDFMAker needs to save the file before continuing. Do you want PDFMaker to save the file and continue?
This question does not occur with documents created by templates made by MS. I have already saved the file. It has a *.docx extension.
I will involve some experts into your issue to see whether they can help you. There might be some time delay, thanks for you patience.
Tom Xu [MSFT] MSDN Community Support | Feedback to us
Thanks for sending us your question. You mentioned the following: (2) Go to the Adobe tab and click ‘Create PDF’. It creates the file, but also gives the error. (3) The error does not happen if we use Word 2007 native Create PDF or XPS. So, I do not know why this is not working now.
Someone on the forums may be able to provide you an alternative answer, however if the issue is only happening when using the Adobe tab than it is an issue with the Adobe add-in.
I did some searching on the Adobe support site below and was unable to find anything related to this specific issue. http://helpx.adobe.com/support/
My first recommendation would be to make sure you have any updates for the Adobe add-in that may be available. You may also want to contact Adobe directly to see if they are aware of this issue and whether they have any recommendations for you.
Travis Oelschlager Microsoft Online Community Support
IT also happend with PDF Nuance. I have already contected Adobe. They say the issue is with Microsoft not them. I have all updates. We’ve actually moved on to version XI now and still have the same problem.
I have a few things you can try to see if they help at all. 1) If you have both of the add-ins installed for PDF Nuance and Adobe it is possible they could be conflicting and causing the issue. Does the issue happen if you uninstall one of those add-ins? 2) Based on your description this is only happening with the 3rd party templates that have VBA code behind them. You can also try the following settings in excel to see if they change the behavior: — Go to the Office Button and choose word options. — Click the Trust Center and Trust Center Settings. — They can test the following settings: A) On the Macro settings tab, check the box for Trust access to the VBA project object model B) On the Macro setting tab, select the «Enable all macros» setting. C) On the ActiveX Settings tab, select the «Enable all controls without restrictions and without prompting» D) On the trusted locations tab, add a trusted location for the document and the document you are saving.
Travis Oelschlager Microsoft Online Community Support
I too, get this error, do not have Nuance installed, only AA Pro 11
In Excel, you can change the macro security settings to control which macros run and under what circumstances when you open a workbook. For example, you might allow macros to run based on whether they are digitally signed by a trusted developer.
For more information about macro security settings in Microsoft Office documents, see Enable or disable macros in Office files.
The following list summarizes the various macro security settings. Under all settings, if antivirus software that works with Microsoft Office is installed and the workbook contains macros, the workbook is scanned for known viruses before it is opened.
Disable all macros without notification Click this option if you don’t trust macros. All macros in documents and security alerts about macros are disabled. If there are documents that contain unsigned macros that you do trust, you can put those documents into a trusted location. Documents in trusted locations are allowed to run without being checked by the Trust Center security system.
Disable all macros with notification This is the default setting. Click this option if you want macros to be disabled, but you want to get security alerts if there are macros present. This way, you can choose when to enable those macros on a case by case basis.
Disable all macros except digitally signed macros This setting is the same as the Disable all macros with notification option, except that if the macro is digitally signed by a trusted publisher, the macro can run if you have already trusted the publisher. If you have not trusted the publisher, you are notified. That way, you can choose to enable those signed macros or trust the publisher. All unsigned macros are disabled without notification.
Enable all macros (not recommended, potentially dangerous code can run) Click this option to allow all macros to run. Using this setting makes your computer vulnerable to potentially malicious code and is not recommended.
Trust access to the VBA project object model This setting is for developers and is used to deliberately lock out or allow programmatic access to the VBA object model from any Automation client. In other words, it provides a security option for code that is written to automate an Office program and programmatically manipulate the Microsoft Visual Basic for Applications (VBA) environment and object model. This is a per user and per application setting, and denies access by default. This security option makes it more difficult for unauthorized programs to build «self-replicating» code that can harm end-user systems. For any Automation client to be able to access the VBA object model programmatically, the user running the code must explicitly grant access. To turn on access, select the check box.
Office uses Microsoft Authenticode technology to enable macro creators to digitally sign a file or a macro project. The certificate that is used to create this signature confirms that the macro or document originated from the signer, and the signature confirms that the macro or document has not been altered.
After you install your digital certificate, you can sign files and macro projects.
Obtaining a digital certificate for signing
You can obtain a digital certificate from a commercial certificate authority (CA), or from your internal security administrator or information technology (IT) professional.
To learn more about certificate authorities that offer services for Microsoft products, see the list of Microsoft Root Certificate Program Members.
Creating your own digital certificate for self-signing
You can also create your own self-signing certificate by using the Selfcert.exe tool.
Note: Because a digital certificate that you create isn’t issued by a formal certificate authority, macro projects that are signed by using such a certificate are referred to as self-signed projects. Microsoft Office trusts a self-signed certificate only on a computer that has that certificate in your Personal Certificates store.
For more information about how to digitally sign a macro, see Digitally sign a macro project.
Change macro security settings
You can change macro security settings in the Trust Center, unless a system administrator in your organization has changed the default settings to prevent you from changing the settings.
On the Developer tab, in the Code group, click Macro Security.
To enable the Developer tab, see Show the Developer tab.
In the Macro Settings category, under Macro Settings, click the option that you want.
Note: Any changes that you make in the Macro Settings category in Excel apply only to Excel and do not affect any other Microsoft Office program.
You can also access the Trust Center in Excel Options. To do that, click Options (Excel 2010 to 2016 versions) or Microsoft Office Button (Excel 2007), and then click Trust Center > Trust Center Settings > Macro Settings.
For more information about macro security, see the following topics:
Troubleshooting
I can’t change my macro security settings
Some users may not be able to change Trust Center settings due to group security policies in their organizations. In such cases, you need to contact the IT administrator for your organization.
What happened to the Very High, High, Medium, and Low security settings?
Excel 2003 setting
Excel 2007/2010/2013/2016 equivalent
Disable all macros without notification
In Excel 2003, VBA macros can run only if the Trust all installed add-ins and templates option (in Excel 2003, the Trusted Publishers tab in the Security dialog box) is selected and the macros (whether signed or unsigned) are stored in a specific trusted folder on the user’s hard disk.
If not all of these conditions are met, VBA macros cannot run under the Very High security setting in Excel 2003.
Disable all macros except digitally signed macros
By default, all Office 2003 programs are installed with macro security set to High.
Disable all macros with notification
In Excel 2003, users are prompted to enable or disable executables when a document is opened. This level requires the acceptance of a certificate of trust for each executable, which is accepted by adding the certificate to a segment of the computer’s Windows registry.
Subsequent requests to run a macro from a trusted source are automatically accepted (the executable runs without prompting the user).
Enable all macros (not recommended; potentially dangerous code can run)
In Excel 2003, all macros are run without restrictions. This security level does not protect against malicious programs, does not allow for acceptance of certificates of trust, and is not considered secure in general. This level is not recommended.
Need more help?
You can always ask an expert in the Excel Tech Community or get support in the Answers community.
Профиль | Отправить PM | Цитировать
(Excel 2007), and then click Trust Center > Trust Center Settings > Macro Settings.