Macro to close/open data validation workbook

[catccc]

I've created a file that contains a list of valid data (validdata.xls)that will be used for a series of other files (info1.xls).

I also created a macro which is triggered upon opening info1.xls that will automatically open and hide validdata.xls.

I would like to create a macro that closes the validdata.xls file w/o prompting the user to save changes.

Right now, everything seems to work, except that upon closing info1.xls, it will ask the user if he/she would like to save changes validdata.xls.

Is there any way around this prompt?

[Leith Ross]

Hello catccc,

You can set the argument "SaveChanges" to False to prevent the prompt from being displayed.

Please Login or Register  to view this content.

[catccc]

Awesome, thanks so much for the assistance, Leith Ross! It works perfectly now.