I'd like to start a existing routing off with a a "save as" dialogue, if the document is not in saved status.
i think it would look something like this (i commented the parts I don't know how to write)
[VBA]
If ActiveWorkbook.Saved = False Then
'open save as command Then
'if the save as is canceled
Exit Sub
End If
Else
'go on with the routine
[/VBA]
What this should accomplish, is that it checks if the document is in saved status or not, and if not, that it asks you to save first. if you cancel the save it will exit the whole routine. if the do save, or it's saved allready, then the routing goes on.
Any want to fill in the gaps?