I have a command button that saves my workbook with a new name generated from two different cells. I have looked over many threads and can't quite figure out how to solve my problem: when a user enters a name that already exists and clicks the button, it tells them that the file name exists and they can choose whether or not to replace it. If they click "cancel" or "no" then they receive an error. Can someone help me find a way to enable them to choose no or cancel without getting this error?
Here is the code I have so far:
It works wonderfully except for when the user accidentally saves it when the file name already exists and they choose to cancel the action. Any help would be appreciated!Please Login or Register to view this content.
Thanks in advance
Bookmarks