Excel 2007 : Archive Macro Modification, Unhide/Hide addition

[Martin Chamberlin]

The attached sheet has a Macro which archives cells A1 to C1 from "Enter Data" sheet into "Archive" sheet at the next empty cells. (Just hit button 1)

I need to hide "Archive" sheet.

The Macro therefore needs modifying to unhide and then re hide "Archive" sheet.

I need the help of an Excel Wizz again. Thanks in advance of Forum support,

Chambo

ps Heres the Macro that is currently good:

[Sub Macro2()

Dim LastRow As Double

Sheets("Enter Data").Select
Range("a1:c1").Select
Selection.Copy

Sheets("Archive").Select
LastRow = Cells(Rows.Count, "A").End(xlUp).Row
Cells(LastRow + 1, "A").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False

Sheets("Enter Data").Select
Range("A2").Select
Application.CutCopyMode = False
End Sub]


Solved

I worked it out. If anyone wants a copy let me know

Chambo