[ExcelVBA] How do you skip over or pre-answer an EXCEL dialog box?

 

I finished my expansion of my VB Macro to compare two spreadsheets. When I try and save the .XLSM to a .XLSX file, I am receiving a prompt that reads as follows:

The Title contains "Microsoft Excel"

The body of the dialog box reads as follows:

The following features cannot be saved in macro-free workbooks:

. VB Project

To save a file with these features, click No, and then choose a macro-enabled file type in the File Type list.

To continue saving as a macro-free workbook, click Yes.

The buttons that appear are:

Yes, No, and Help

I would like to force the Yes button.

How do I do that?

The statement that this is trying to execute in my Macro is:

ActiveWorkbook.Close SaveChanges:=False

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 6

Visit Your Group

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___