Saving results as next worksheet

[nathanpeattie]

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

 

[lozzablake]

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?

 

[nathanpeattie]

Thanks for the reply I came up with another way of doing what I needed.

Thanks