VBA select default Don't Enable / Enable macros Setting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The file that the following calls up, requires an "enter",
to accept the default yes/no statement (actually "do NOT
Sub BB_Chassis_Draft()
Application.ScreenUpdating = False
Workbooks.Open ("S:\10_SALES
MANUALS\Z_JFS\0_Spread_Sheets\10_Modifications\7_NEW
2006\4_Updating\BB-Pup-Chassis-2006_R1C0.xls")
Application.ScreenUpdating = True
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

choose default macros Not Enabled / Macros Enable Setting 2
Sharing xls file with macro (xlsm) 0
Macro Enable/Disable 2
Problem Saving with the 'Must Enable Macro' workaround 3
Enable/Disable Macro 2
Anyone Know Workbook Openening & Saving Macro Alternatives? 2
Don't want to hard-code file name in macro 3
"Sendmail" macro to multilpe addresses 8

Back
Top