SaveAs box cancel

[milo1984]

Hi,

I have a macro with

Application.Dialogs(xlDialogSaveAs).Show

in it

if the saveAs box is cancelled, it goes to the next line of the sub instead of exiting. what do I need to add in to move to Exit Sub if the Cancel is selected?

many thanks in advance.

[xlnitwit]

Hi,

It returns a Boolean so

If Application.Dialogs(xlDialogSaveAs).Show = False Then Exit Sub

or

If Not Application.Dialogs(xlDialogSaveAs).Show Then Exit Sub

[milo1984]

perfect thanks

[xlnitwit]

You're welcome. Thanks for the rep.