View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Cerberus Cerberus is offline
external usenet poster
 
Posts: 88
Default Control a worksheet w/o activating

I have a worksheet ("Cut") that has a hide macro associated with a worksheet
activation. I would like to unhide that page when I activate another
worksheet ("Order").

I have tried:

Private Sub Worksheet_Activate()
Sheets ("Cut")
Cells.Select
Selection.EntireRow.Hidden = False
End Sub

But obviously that is not the answer. Any ideas? Thanks in advance for
your assistance.