I have this macro which currently copies the template sheet to be used as a template for a new month.
I would like to hide this sheet and still have it work, but it doesn't work when I hide it. Is there a way to do this?
Sub CopyandPaste()
On Error Resume Next
Windows("Test 2017.xlsm").Activate
Sheets("Template").Select
Sheets("Template").Copy Before:=Workbooks("Test 2017.xlsm").Sheets("Yearly Data")
End Sub
Bookmarks