ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Trust Access to Visual Basic Project - Access to Excel and back (https://www.excelbanter.com/excel-programming/403816-trust-access-visual-basic-project-access-excel-back.html)

tcb

Trust Access to Visual Basic Project - Access to Excel and back
 
From an Access program spreadsheets with command buttons with code are
created. Is it possible to check to see if the user has "Trust Access
to Visual Basic Project" enabled? Would it also be possible to send
something like boolVBPenabled = true or false back to the Access
program?

I think it would be possible to open a spreadsheet, check the
setting, and prompt the user from Excel to please enable Trust Access
to Visual Basic Project, but I'd actually like them to get the message
in the Access program.


All times are GMT +1. The time now is 02:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com