Save by using command button in excel 2007

by balaji.iitr . Updated 15 years, 12 months ago

I am developing a design tool in excel 2007,
i want SAVEAS option in command button, this command button should save the current work sheet data only, before save window option also as same as (File>Saveas) option.

does any one know, pls help me..