Hi, guys. I am facing a problem and I need some help, please.
I have a workbook with a macro that prompts the user to enter a value in D1 and when he does it, a 'Save as' window automatically appears to save the file as a new one. That part works fine. The problem is when the user clicks the 'Cancel' button, it still saves a file named 'False' in the selected directory.
How do I avoid this?
This is the piece of code to save the workbook as a new one:
Thank you so much.Please Login or Register to view this content.
Bookmarks