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
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