Custom Save As

J

JAO

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top