knightwriter
New Member
- Joined
- Jul 4, 2016
- Messages
- 17
Hi all,
I am using a standard code to by pass the save changes prompt but instead of saving automatically and closing, the save prompt shows and when I select Yes, its prompts again and again. By only selecting Cancel will it disappear.
Any suggestions how to fix this? Or what may cause this?
Many thanks
I am using a standard code to by pass the save changes prompt but instead of saving automatically and closing, the save prompt shows and when I select Yes, its prompts again and again. By only selecting Cancel will it disappear.
Any suggestions how to fix this? Or what may cause this?
Many thanks
Code:
Workbooks(strSourceWorkbook).Close SaveChanges:=True