I have a macro that updates eleven different works when initiated. Each of the workbooks has a "beforeClose" macro that saves the active workbook. The macro opens the first workbook, updates and formats data. The macro then closes the work book using "ActiveWorkBook.Close". The macro moves onto the next workbook but not before prompting "Do you want to save changes". Why does this prompt come up when the workbook already has code to save when it closes? I have added "ActiveWorkbook. Save" which seems to eliminate the prompt but the workbook ends up saving twice. Any ideas why this is happening??
