Hi,
I'm currently trying to create a new workbook by using a macro-assigned button in an existing workbook. I need the macro to open a new workbook, copy the two hidden sheets (called "Targets" and "Template") into the new workbook and re-hide them, and then start a new worksheet for the first of the month, using the Template worksheet. The name for the first worksheet of the month needs to be the date, which is copied from the Targets sheet (cell B40). This date just needs to be a user prompt, and gets updated as the month goes along and new sheets are made (which I already have completed the code for). I'm just stuck trying to get the new workbook to open. Help?
I'm currently trying to create a new workbook by using a macro-assigned button in an existing workbook. I need the macro to open a new workbook, copy the two hidden sheets (called "Targets" and "Template") into the new workbook and re-hide them, and then start a new worksheet for the first of the month, using the Template worksheet. The name for the first worksheet of the month needs to be the date, which is copied from the Targets sheet (cell B40). This date just needs to be a user prompt, and gets updated as the month goes along and new sheets are made (which I already have completed the code for). I'm just stuck trying to get the new workbook to open. Help?
