ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   control of dialog macro dialog box. on open (https://www.excelbanter.com/excel-programming/304745-control-dialog-macro-dialog-box-open.html)

Gerry Abbott

control of dialog macro dialog box. on open
 
Hi all
I'm opening a workbook which has macro code in it, from Access, and copying
data out.

I'm getting the dialog box warning me about macro code. I want to
automatically disable the macros, then get access to the data. Is there a
way I can via code, control an input to this dialog box, i.e.
automatically selet Yes from the 'yes' 'no' 'cancel' dialog.

Thanks

Gerry Abbott



--





All times are GMT +1. The time now is 06:41 AM.

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