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.

Private Sub Worksheet_Activate()
Sheets("Cut").Visible = True
end sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
"Cerberus" <(E-Mail Removed)> wrote in message
news:E4425156-F751-40A2-A6E5-(E-Mail Removed)...
>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.

Do you mean unhide rows on "Cut", or unhide the entire sheet?

Private Sub Worksheet_Activate()
'To unhide the sheet
Sheets("Cut").Visible = xlSheetVisible
'To unhide rows - adjust the range to include the rows you want unhidden
Sheets("Cut").range("A1:A5").entirerow.hidden = false
End Sub

--
---
http://excelninja.blogspot.com


"Cerberus" wrote:

> 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.

Unhide rows on "Cut" but not leave the "Order" worksheet.

"Jayson" wrote:

> Do you mean unhide rows on "Cut", or unhide the entire sheet?
>
> Private Sub Worksheet_Activate()
> 'To unhide the sheet
> Sheets("Cut").Visible = xlSheetVisible
> 'To unhide rows - adjust the range to include the rows you want unhidden
> Sheets("Cut").range("A1:A5").entirerow.hidden = false
> End Sub
>
> --
> ---
> http://excelninja.blogspot.com
>
>
> "Cerberus" wrote:
>
> > 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.

This should do it. Place this in the "Order" worksheet code.

Private Sub Worksheet_Activate()
'To unhide rows - adjust the range to include the rows you want unhidden
Sheets("Cut").Range("A1:A5").EntireRow.Hidden = False
End Sub

--
---
http://excelninja.blogspot.com


"Cerberus" wrote:

> Unhide rows on "Cut" but not leave the "Order" worksheet.
>
> "Jayson" wrote:
>
> > Do you mean unhide rows on "Cut", or unhide the entire sheet?
> >
> > Private Sub Worksheet_Activate()
> > 'To unhide the sheet
> > Sheets("Cut").Visible = xlSheetVisible
> > 'To unhide rows - adjust the range to include the rows you want unhidden
> > Sheets("Cut").range("A1:A5").entirerow.hidden = false
> > End Sub
> >
> > --
> > ---
> > http://excelninja.blogspot.com
> >
> >
> > "Cerberus" wrote:
> >
> > > 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.

Worked like a charm. Thank you for your help on this.

"Jayson" wrote:

> This should do it. Place this in the "Order" worksheet code.
>
> Private Sub Worksheet_Activate()
> 'To unhide rows - adjust the range to include the rows you want unhidden
> Sheets("Cut").Range("A1:A5").EntireRow.Hidden = False
> End Sub
>
> --
> ---
> http://excelninja.blogspot.com
>
>
> "Cerberus" wrote:
>
> > Unhide rows on "Cut" but not leave the "Order" worksheet.
> >
> > "Jayson" wrote:
> >
> > > Do you mean unhide rows on "Cut", or unhide the entire sheet?
> > >
> > > Private Sub Worksheet_Activate()
> > > 'To unhide the sheet
> > > Sheets("Cut").Visible = xlSheetVisible
> > > 'To unhide rows - adjust the range to include the rows you want unhidden
> > > Sheets("Cut").range("A1:A5").entirerow.hidden = false
> > > End Sub
> > >
> > > --
> > > ---
> > > http://excelninja.blogspot.com
> > >
> > >
> > > "Cerberus" wrote:
> > >
> > > > 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.

Sheets use the "Visible" property and rows use the "Hidden" property.
Visible can be used two ways with a sheet:

Object.Visible = (xlSheetVisible or xlSheetHidden)
Object.Vixible = (True or False)

More details in the VBA help file under Visible Property



"Cerberus" <(E-Mail Removed)> wrote in message
news:2FD030C5-DCA3-4395-BE0C-(E-Mail Removed)...
> Unhide rows on "Cut" but not leave the "Order" worksheet.
>
> "Jayson" wrote:
>
>> Do you mean unhide rows on "Cut", or unhide the entire sheet?
>>
>> Private Sub Worksheet_Activate()
>> 'To unhide the sheet
>> Sheets("Cut").Visible = xlSheetVisible
>> 'To unhide rows - adjust the range to include the rows you want
>> unhidden
>> Sheets("Cut").range("A1:A5").entirerow.hidden = false
>> End Sub
>>
>> --
>> ---
>> http://excelninja.blogspot.com
>>
>>
>> "Cerberus" wrote:
>>
>> > 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.

sheets("Cut").rows.hidden=false

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
"Cerberus" <(E-Mail Removed)> wrote in message
news:2FD030C5-DCA3-4395-BE0C-(E-Mail Removed)...
> Unhide rows on "Cut" but not leave the "Order" worksheet.
>
> "Jayson" wrote:
>
>> Do you mean unhide rows on "Cut", or unhide the entire sheet?
>>
>> Private Sub Worksheet_Activate()
>> 'To unhide the sheet
>> Sheets("Cut").Visible = xlSheetVisible
>> 'To unhide rows - adjust the range to include the rows you want
>> unhidden
>> Sheets("Cut").range("A1:A5").entirerow.hidden = false
>> End Sub
>>
>> --
>> ---
>> http://excelninja.blogspot.com
>>
>>
>> "Cerberus" wrote:
>>
>> > 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.