I’m looking for a way to confirm the excel settings between two environments/machines. For instance, how can I confirm settings in the Trust Center to make sure the “Trust Access to the VBA project object model” is checked. We have a testing/UAT environment and a production environment. I did not see a way to “export” the settings from excel and compare.
Related Topics
Topic | Replies | Views | Activity | |
---|---|---|---|---|
Invoke VBA is not working | 15 | 961 | April 20, 2023 | |
How to automate the excel to enable trust centre | 2 | 845 | May 20, 2022 | |
Error: Invoke VBA: Programmatic access to Visual Basic Project is not trusted | 7 | 23797 | March 27, 2020 | |
Excel allow user to change environment | 8 | 258 | September 20, 2023 | |
Can't indicate elements in excel | 5 | 159 | August 29, 2023 |