![]() ![]() ![]() Next, switch to the Macro Settings tab and tick the Trust access to the VBA project object model checkbox.Ĭlick the OK button to save the change. Then, switch to the Trust Center tab and click on the Trust Center Settings button. To know more about these steps, continue reading.įirst, you need to open Microsoft Excel or Word or PowerPoint and click the Options visible in the bottom left corner. Tick the Trust access to the VBA project object model checkbox.Click the Trust Center Settings button.Open Microsoft Excel and click on Options.To enable or disable Trust access to Visual Basic Project in Office apps, follow these steps: Enable or disable Trust access to Visual Basic Project in Office apps However, you can use Word or PowerPoint as well. Note: In every instance, we have used Microsoft Excel for demonstrations. Many times, such codes may not work correctly until or unless you turn on the Trust access to Visual Basic Project setting. In such situations, you can use Visual Basic to get things done manually. At times, you might need to do something in the Excel spreadsheet, and the corresponding option is not present. VBA Project Model helps users run various codes from any automation client. What is Trust access to the VBA project model? If you want to enable or disable Trust access to Visual Basic Project in Office apps, such as Word, Excel, PowerPoint, etc., you can do so with the help of the in-built option, Local Group Policy Editor, and Registry Editor.
0 Comments
Leave a Reply. |