I am not convinced I understand the problem. BUT ..
If you want Excel to behave as if the activeworkbook had not been saved, se

ActiveWorkBook.Saved = Fals

Or if you want Excel to behave as if the workbook had been saved, se

ActiveWorkBook.Saved = True