Macro to save copy of worksheet.

wrightyrx7

wrightyrx7

Well-known Member
Joined
Sep 15, 2011
Messages
994
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
 

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"
Sort by date Sort by votes
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
 
Upvote 0
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
 
Upvote 0
Chris

Is this button going to be on every worksheet?
 
Upvote 0
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.
 
Upvote 0
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?
 
Upvote 0
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
 
Upvote 0
You must log in or register to reply here.

Similar threads

N
  • Question Question
VBA to add title from formula to a save as name
Replies
0
Views
138
NKUNZI
N
D
  • Question Question
Modify a worksheet without registering it as a change
Replies
1
Views
103
Kaper
Kaper
T
  • Question Question
Save As Dialog Box with File Name Predetermined for Ppt file through Excel
2
Replies
10
Views
200
tbakbradley
T
T
  • Question Question
VBA Stuck Sanitising Several Sheets
Replies
2
Views
216
Tarkemelion
T
B
  • Solved
Macro for "Clearcontents" button
Replies
7
Views
115
Peter_SSs
Peter_SSs

Forum statistics

Threads
1,224,521
Messages
6,179,275
Members
452,902
Latest member
Knuddeluff

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top