If SaveAs cancelled then do something

[Steve@Rugby]

Hi,

Can anyone advise of a code that detects SaveAs has been canceled?

What i would like to be able to do in VBA is if a user doesnt press the cancel button in the SaveAs window then do something, else cancel button has been pressed, do something else.

Something along the lines of

Please Login or Register  to view this content.

Regards
Steve

[G e r a r d]

The info provided is poor, but maybe this can help you.

Please Login or Register  to view this content.

Gerard

[Steve@Rugby]

Hi Gerrad,

Thanks for your help, yes that was what I needed managed to adapt it to my needs as below:

Please Login or Register  to view this content.

Regards
Steve