Save & Rename Worksheet

I know how to save a worksheet to the bar below. Being a little lazy and inquisitive is there a way to use a button, with a macro to achieve the same thing?

Thanks

Here's another suggestion by Mumps1 from another thread:

Please Login or Register  to view this content.

Artik

thanks everyone

Hi in your second reply at

Do
strNewName = InputBox("Enter the new sheet name:", "New name", ActiveSheet.Name) can I just enter the cell name "B3" at "Enter the new sheet name:"

I don't know if I understood correctly.
Perhaps

Please Login or Register  to view this content.

Artik