cancelling saveas dialog gets error 1004

[greegan]

So i have the macro checking for an existing file name. works
I have it bring up an input box to change the name. works... kind of
OK is fine, it renames the file with whatever i have used.
If i cancel i get error 1004.
I need to fix this, and...
is there a way to control what happens when "true" xl dialog boxes are prompted with the Yes, No, Cancel, OK buttons?

-- g

 

[Richard Schollar]

It's really difficult to help when you don't provide the actual code you are using - we end up having to make a lot of assumptions about exactly what you are doing which may be wrong and thus waste our's and your time. So please provide the code and indicate in which line it errors.

 

[greegan]

Fair enough.
I will post it in the morning.
Thank you for your response.