View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gerry Abbott Gerry Abbott is offline
external usenet poster
 
Posts: 6
Default 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



--