You might be able to modify the "Save Changes?" example on my web site.

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Bill D." wrote in message
...

I want to put a Save AS button on a worksheet that will open the Windows
SaveAs dialog box so the user can select the path to where he wants the
worksheet saved. An inputbox will ask for the new file name prior to
opening the SaveAs dialog box.

Bill

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!