I think the solution is as simple as adding "objMap.Saved = True" to your VBA code. This basically tells MapPoint that there are no changes to the map so it won't prompt you to save changes when you exit.