Hide/show worksheet

Is there a way of automaticly hidind or showing a
worksheet. I have about 12 sheets on 3 different subjects
and would like to show the sheets only that I want to use
auto. I can use macros.
Thanks

Good morning Mal

You could use macros if you wanted, but have you tried looking at the View > Custom Views... option (alt + v twice)? Set your sheet how you want it to look to work with subject A, and add it as a view. Do the same with the next two subjects. You change views from the same dialog box

HTH

DominicB

There needs to be some sort of rule/criteria for determining what gets
hidden/shown, and when. What are those rules?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Mal" <[email protected]> wrote in message
news:[email protected]...
> Is there a way of automaticly hidind or showing a
> worksheet. I have about 12 sheets on 3 different subjects
> and would like to show the sheets only that I want to use
> auto. I can use macros.
> Thanks

There are 3 sheets that I would like to show at all
times. I would like the linked sheets to appear when I
enter one of these 3 sheets. EG when I clich on sheet
one, 7 of the linked sheets appear, click on another and
the first 7 dissapear and the new 6 appear.
Thanks
Mal
>-----Original Message-----
>There needs to be some sort of rule/criteria for
determining what gets
>hidden/shown, and when. What are those rules?
>
>--
>
>HTH
>
>RP
>(remove nothere from the email address if mailing direct)
>
>
>"Mal" <[email protected]> wrote in
message
>news:[email protected]...
>> Is there a way of automaticly hidind or showing a
>> worksheet. I have about 12 sheets on 3 different
subjects
>> and would like to show the sheets only that I want to
use
>> auto. I can use macros.
>> Thanks
>
>
>.
>

How do we know what are linked to the sheet?

--

HTH

RP
(remove nothere from the email address if mailing direct)


<[email protected]> wrote in message
news:[email protected]...
> There are 3 sheets that I would like to show at all
> times. I would like the linked sheets to appear when I
> enter one of these 3 sheets. EG when I clich on sheet
> one, 7 of the linked sheets appear, click on another and
> the first 7 dissapear and the new 6 appear.
> Thanks
> Mal
> >-----Original Message-----
> >There needs to be some sort of rule/criteria for
> determining what gets
> >hidden/shown, and when. What are those rules?
> >
> >--
> >
> >HTH
> >
> >RP
> >(remove nothere from the email address if mailing direct)
> >
> >
> >"Mal" <[email protected]> wrote in
> message
> >news:[email protected]...
> >> Is there a way of automaticly hidind or showing a
> >> worksheet. I have about 12 sheets on 3 different
> subjects
> >> and would like to show the sheets only that I want to
> use
> >> auto. I can use macros.
> >> Thanks
> >
> >
> >.
> >

The linked sheets have relivant data to one of the main 3
sheets.
Thanks
Mal
>-----Original Message-----
>How do we know what are linked to the sheet?
>
>--
>
>HTH
>
>RP
>(remove nothere from the email address if mailing direct)
>
>
><[email protected]> wrote in message
>news:[email protected]...
>> There are 3 sheets that I would like to show at all
>> times. I would like the linked sheets to appear when I
>> enter one of these 3 sheets. EG when I clich on sheet
>> one, 7 of the linked sheets appear, click on another
and
>> the first 7 dissapear and the new 6 appear.
>> Thanks
>> Mal
>> >-----Original Message-----
>> >There needs to be some sort of rule/criteria for
>> determining what gets
>> >hidden/shown, and when. What are those rules?
>> >
>> >--
>> >
>> >HTH
>> >
>> >RP
>> >(remove nothere from the email address if mailing
direct)
>> >
>> >
>> >"Mal" <[email protected]> wrote in
>> message
>> >news:[email protected]...
>> >> Is there a way of automaticly hidind or showing a
>> >> worksheet. I have about 12 sheets on 3 different
>> subjects
>> >> and would like to show the sheets only that I want
to
>> use
>> >> auto. I can use macros.
>> >> Thanks
>> >
>> >
>> >.
>> >
>
>
>.
>

Sorry, but if you want a solution, you will need to be more forthcoming.
Relevant could mean any number of things. Code expects exact definitions.

--

HTH

RP
(remove nothere from the email address if mailing direct)


<[email protected]> wrote in message
news:[email protected]...
> The linked sheets have relivant data to one of the main 3
> sheets.
> Thanks
> Mal
> >-----Original Message-----
> >How do we know what are linked to the sheet?
> >
> >--
> >
> >HTH
> >
> >RP
> >(remove nothere from the email address if mailing direct)
> >
> >
> ><[email protected]> wrote in message
> >news:[email protected]...
> >> There are 3 sheets that I would like to show at all
> >> times. I would like the linked sheets to appear when I
> >> enter one of these 3 sheets. EG when I clich on sheet
> >> one, 7 of the linked sheets appear, click on another
> and
> >> the first 7 dissapear and the new 6 appear.
> >> Thanks
> >> Mal
> >> >-----Original Message-----
> >> >There needs to be some sort of rule/criteria for
> >> determining what gets
> >> >hidden/shown, and when. What are those rules?
> >> >
> >> >--
> >> >
> >> >HTH
> >> >
> >> >RP
> >> >(remove nothere from the email address if mailing
> direct)
> >> >
> >> >
> >> >"Mal" <[email protected]> wrote in
> >> message
> >> >news:[email protected]...
> >> >> Is there a way of automaticly hidind or showing a
> >> >> worksheet. I have about 12 sheets on 3 different
> >> subjects
> >> >> and would like to show the sheets only that I want
> to
> >> use
> >> >> auto. I can use macros.
> >> >> Thanks
> >> >
> >> >
> >> >.
> >> >
> >
> >
> >.
> >