Hi Guyz,
I am a newbie to VBA coding. Therefore I am not sure if this is possible or not.
Basically I want to make a button which when clicked once will go make a copy of a sheet named "template", but when it copies it will tell the user to enter the name of sheet. And once the user makes that new sheet and fills in the fields in the new sheet, the next time he clicks the same button it will take him to the page he has created before when he clicked the button the first time. Hope this makes sense
For example , User clicks the button "noob", excel makes a copy of a sheet named template in the workbook and asks the user to enter the name of the sheet, the user enters the name of the sheet as template 22 and fills in this sheet. Next time the user clicks the button "noob" it will take him to the sheet template22.
I am using this code to make new sheet as of now
Plzzzzzz help!
Bookmarks