Help with custom save as dialog box.

C

control freak

Hello, i am using the following code to promt the user to save a
workbook (so they dont overwrite the template, name of save is based on
cell b2.


Set wbDestination = Workbooks.Add
Excel.Application.Dialogs(xlDialogSaveAs).Show Range("b2")


It works fine unless i click cancel, it still saves the book (just
calling it book1) any way to make the cancel button actually cancel the
operation in my macro?


Any help is appreciated

Thank you

Troy
 
Top