How to check if "Trust access to the VBA project object model" has been enabled on machine

I don't think there is a property to test.
Instead you can create your own function which uses error trapping.

Please Login or Register  to view this content.

Appears to work with limited testing.

Originally Posted by Andy Pope

I don't think there is a property to test.
Instead you can create your own function which uses error trapping.

Please Login or Register  to view this content.

Appears to work with limited testing.

If the workbook that contains the code above is closed, then re-opened in the same Excel session (meaning don't Exit Excel) the check won't work. When I put it in my workbook Open event it worked the first time but when I closed the file and then re-opened it in the same Excel session the Workbook_Open event didn't even fire off!

Please Login or Register  to view this content.

Excel 2010 in Windows 7

Originally Posted by Andy Pope

I don't think there is a property to test.
Instead you can create your own function which uses error trapping.

Please Login or Register  to view this content.

Appears to work with limited testing.

I don't quite understand how it's possible to let this work.

When put in the Workbook_Open event, there's naturally no problem if "Trust access to the VBA project object model" is enabled in Excel, but if it's not enabled, the VBA code can not even be executed from Workbook_Open, so no message box will be shown and in my case my Workbook cannot be opened and Excel freezes.

I would be grateful if you could help me further and explain me how I could definitely have a message shown if "Trust access..." is not enabled. It's a fact the VBA code can not be run if "Trust access..." is not enabled.

Jacques

Originally Posted by john456852

pls post a sample

Not necessary. It's solved now. The code above is working. There were other entries in the Workbook _Open event preventing the code from working (properly). I managed things with an "If-Then-Else" construct.