Custom Save As
 

I have written some VBA code that calls the Save As dialogue box and inserts
a suggested Save As filename, but I need some help with three (hopefully
minor) items:

1) How can I add code that will perform an action if the user chooses
"Cancel" on the Save As dialogue box?

2) How can I force the default Save As directory to be the current working
directory?

3) Can I disable an entire "Sub" routine when the user chooses "OK" from the
Save As dialogue box?