cancelling saveas dialog gets error 1004

greegan

Well-known Member
Joined
Nov 18, 2009
Messages
640
Office Version
  1. 365
Platform
  1. Windows
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
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

Richard Schollar

MrExcel MVP
Joined
Apr 19, 2005
Messages
23,707
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

Well-known Member
Joined
Nov 18, 2009
Messages
640
Office Version
  1. 365
Platform
  1. Windows
Fair enough.
I will post it in the morning.
Thank you for your response.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,424
Messages
5,831,538
Members
430,074
Latest member
Francis101

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top