Macro does not work when I move / copy sheet within the same workbook

I am a new user of macros, but every month I have to create a new dashboard that I show "Open" for me to enter the information, and "Closed" so the managers see the totals only. I did not write the macro, I just recorded it.
I recorded the following macro in my sheet "September", but when I use the "Move or Copy" to create the sheet and rename it October (this is within the same file), the macro does not work in the new sheet. This is a basic macro to hide and unhide rows and columns. (error 400)
Please help;

Sub ShowClosed()
'
' ShowClosed Macro
'

'
    ActiveWindow.LargeScroll ToRight:=-1
    Columns("B:J").Select
    Selection.EntireColumn.Hidden = True
    Rows("4:10").Select
    Selection.EntireRow.Hidden = True
    Rows("12:19").Select
    Selection.EntireRow.Hidden = True
    Rows("21:28").Select
    Selection.EntireRow.Hidden = True
    Rows("30:37").Select
    Selection.EntireRow.Hidden = True
    Rows("39:46").Select
    Selection.EntireRow.Hidden = True
    Rows("48:48").Select
    Selection.EntireRow.Hidden = True
End Sub

Sub ShowOpen()
'
' ShowOpen Macro
'

'
    Columns("A:O").Select
    Selection.EntireColumn.Hidden = False
    Rows("2:53").Select
    Selection.EntireRow.Hidden = False
    Range("F10").Select
End Sub