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?