Sub TEST1()
with Sheets("Sheet3")
.visible = xlsheetvisible
.Select
end with
End Sub

Will make it visible and then select that sheet.

But I would guess that you want that sheet to disappear when you click on
another sheet?

If yes, rightclick on Sheet3's tab and select view code. Paste this into the
code window:

Option Explicit
Private Sub Worksheet_Deactivate()
Worksheets("IndexSheetNameHere").Visible = xlSheetVisible
Me.Visible = xlSheetHidden
End Sub

Change that name "indexsheetnamehere" to match the worksheet that will always be
visible.

It just verifies that it's visible before it tries to hide sheet3.



murph306 wrote:
>
> it was a simple macro from one sheet to another:
>
> Sub TEST1()
> '
> ' TEST1 Macro
> ' Macro recorded 01/06/2006 by KMC
> '
>
> '
> Sheets("Sheet3").Select
> End Sub
>
> however once the worksheet was hidden the macro no longer worked
>
> --
> murph306
> ------------------------------------------------------------------------
> murph306's Profile: http://www.excelforum.com/member.php...o&userid=35000
> View this thread: http://www.excelforum.com/showthread...hreadid=547392

--

Dave Peterson