how to save a sheet using buttons in excel

[semeer]

how to save an excel sheet using button

[FDibbins]

Use the macro recorder. Turn it on by clicking on the icon next to the READY icon at the bottom left of the excel window. This will record every action you do. When you have saved the file, "stop" the recorder.

Then create a shape where you want the button to be, right-click on that shape and assign the macro to it

[semeer]

is there any code to save the sheet1 only. i want a save button to save the sheet 1 only not whole workbook

[FDibbins]

unless some-one can give you better code for this, 1 option would be, while still in record mode, to delete all the other sheets, and then SAVE AS with a different name. That way, your original file remains untouched, and you end up saving just the sheet you want...under a different name

[HaHoBe]

Hi, semeer,

Please Login or Register  to view this content.

Right click the worksheet tab, move/copy, check for copy, enter new workbook in Combobox, record that action, work on the macro code as the code will be "hard coded" or ask for modification here.

Ciao,
Holger