I am looking for a macro to duplicate a worksheet within the same workbook and enter the new name in an input box. I searched the forum and found the below code which seems to work fine, however I need a couple of tweaks. I would like the new sheet to keep the zoom level the same as the...