Hi to all
I have recorded macro which copy Sheet1
That works fine until Sheet1 is veryhidden
Sheet1 suppose to be veryhidden cause its template sheet
So, when user fill up sheet2 he need to press button and he will get Sheet1, named Sheet3, u know how that works
I tried avoid that by this:
That didn't help me, I get part "Sheets("Sheet1").Select" colored yellow
I don't know how to fix this, can someone help me?
Thanks
I have recorded macro which copy Sheet1
That works fine until Sheet1 is veryhidden
Sheet1 suppose to be veryhidden cause its template sheet
So, when user fill up sheet2 he need to press button and he will get Sheet1, named Sheet3, u know how that works
I tried avoid that by this:
Code:
Sub copy()
Sheet1.Visible = xlSheetVeryHidden = False
Sheets("Sheet1").Select
Sheets("Sheet1").Copy Before:=Sheets(1)
Sheet1.Visible = xlSheetVeryHidden = True
End Sub
That didn't help me, I get part "Sheets("Sheet1").Select" colored yellow
I don't know how to fix this, can someone help me?
Thanks