Macro to save copy of worksheet.

[wrightyrx7]

Hi all,

I have a Workbook with around 10 worksheets on, each worksheet is a form.

And when one form is completed we have to save a backup. So i want to assign a macro to a button on a worksheet so when clicked it will save a copy of that worksheet ONLY to a destination and not all the other worksheets along with it.

If you get what i mean??

Thanks
Chris

 

[wrightyrx7]

Want to put a bit more information about this can this vba do the following:-
- save copy of active worksheet.
- open the save as box of a specified directory
- default save name as Cells - A9 " " B7 " " E2.xls

Thanks all
Chris

 

[wrightyrx7]

sorry to BUMP this thread guys but i posted it early in the morning when hardly anyone was on. Hoping there are more people on now.

Thanks
Chris

 

[Norie]

Chris

Is this button going to be on every worksheet?

 

[wrightyrx7]

no just the one for now. Then the bos gonna text it with the other members of the team to see how it goes. maybe more in the future.

 

[Norie]

Sorry I don't follow.

There will be only one worksheet in this worbook that needs to be saved to a new workbook and that's where the button will be?

Is the workbook some sort of template?

 

[wrightyrx7]

We have a workbook with 10-15 worksheets with template forms. when we complete one of the forms we have to save a copy of the worksheet for backup. but people savin them in the wrong place. an with the wrong name. plus when we save the backup they save the whole workbook along with it.

lol hope i have explained it enough

 

[Norie]

So where is the button?

 

[wrightyrx7]

i will insert a image and assign the macro to it.

 

[wrightyrx7]

Bump