Thanks JLGWhiz, it works fine in my application but has one niggly problem.
When I open the saved worksheet in the new folder and everytime I
try to close it (without changing anything) it asks me to save changes. Not
a big problem but can this be fixed? or is it "normal"
I have not tried the code from FSt1 yet, but it looks good for another
application I am working on.....Thanks guys for your help. Have a happy and
prosperous new year.
--
ypukpete


"ypukpete" wrote:

I want to save only the active worksheet in a workbook using a command button.
I need the Save As screen to appear so that I can send it to the folder I
require at the time and also give the worksheet a new name, but let me know
if it is invalid. Probably easy when you know how.
I am using excel 2000. Any assistance appreciated
--
ypukpete