Saving results as next worksheet

nathanpeattie

New Member
Joined
Dec 17, 2005
Messages
43
I want to put a button that a user can click that will save the current worksheet to anotherone also I want the user to be able to type in a new for that worksheet on the tab.

Keep in mind that the users that are going to use this workbook are not very excel friendly.

Recap: worksheet1 at the botton of the sheet I want a button that you can press that will ask you for a name for the current worksheet to be saved as in the current workbook.

Thanks
Nathan
 

Some videos you may like

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

lozzablake

Well-known Member
Joined
Dec 15, 2005
Messages
818
you want the current worksheet tobe copied with a new name given by the user. Is the new sheet in the current workbook or in a new workbook?
 

Watch MrExcel Video

Forum statistics

Threads
1,118,327
Messages
5,571,560
Members
412,405
Latest member
DutchMonkey
Top