Contol of Error

[TellM1955]

Hi guys
I have a macro that writes to a pdf and a save box pops up, if I save the file the macro contirues. However, if I don't want to save and cancel the operation I get a Runtime error '1004' Printout of Object 'Sheets' Failed message.
What I would like to do is just continue with the macro when Cancel is pressed. Any help would be greatly appreciated.
Thanks

 

[offthelip]

Have you tried putting:

Application.DisplayAlerts = False

before your code and then

Application.DisplayAlerts = True

after your code??
You could also create your own pop box to "simulate"the choice given to the user by EXCEL

 

[Peter_SSs]

I would suggest that you post your macro code. My signature block below has more about doing that.

 

[Skyybot]

Before the Save dialog put the following:

On Error Resume Next

 

[TellM1955]

Thank you for the responses. The On Error solution worked.