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 | |
---|---|---|---|---|
Set environment agnostic Settings in Config.xlsx (REFramework) | 6 | 486 | December 6, 2023 | |
Invoke VBA is not working | 15 | 1771 | April 20, 2023 | |
Error: Invoke VBA: Programmatic access to Visual Basic Project is not trusted | 7 | 26705 | March 27, 2020 | |
VBA trust issue in excel | 4 | 42 | October 17, 2024 | |
Excel allow user to change environment | 8 | 393 | September 20, 2023 |