I have a command button that clears text boxes and resets values. That part works fine. I then have it ask if you want to save as a new file so not to overwrite data on the previous file. Problem that I am having is that when I say yes I want to save as a new file and when the save as window appears, for testing purposes I changed my mind, I really don't want to save as and click cancel. It still saves a file as false.xlsm. How do I avoid this? I've tried Filename:= and Filename =, and without : I get a file named true.xlsm. For simplicity I reduced the code to just the save as functions without all the clear/rest cell code.
Thank you!!
Bookmarks