Macro and hidden sheets

Hi Alex,

A hidden sheet cannot be selected, so try re-writing your code to remove
selections.

If this does nor resolve your problem, post your code.


---
Regards,
Norman


"Metallo" <Metallo@discussions.microsoft.com> wrote in message
news:AE72C4F3-4EE6-47DD-B83C-AD8AF2A15A7D@microsoft.com...
> Hi,
>
> I have a WB with 10 worksheets.
> At the time I did this WB, I also created a Macro that had the task to
> change the format of all the sheets.
> Today, I have decided to hide some of the sheets and the macro does no
> longer work.
> I guess this is because it cannot find the sheets which are hidden.
>
> My question is: Is there a way to allow the Macro to work as before,
> meaning
> to continue changing the format of the hidden sheets as well?
> Something like a condition that says, if Sheet XY is hidden then look for
> it
> into etc.
>
> Thank you
> Alex
>

Norman,

I am aware that it cannot be selected, but my question was another, that is,
is there a workaround to make the hidden sheets selectable even if they are
hidden?

For instance, the formulas work fine, the values generated as a result of a
calculation turn out in the hidden sheets as if the they were unhidden,
therefore I was wondering: If the formulas work on hidden sheets, why cannot
the macros?

Hope this is clearer.

Thank you!
Alex

"Norman Jones" wrote:

> Hi Alex,
>
> A hidden sheet cannot be selected, so try re-writing your code to remove
> selections.
>
> If this does nor resolve your problem, post your code.
>
>
> ---
> Regards,
> Norman
>
>
> "Metallo" <Metallo@discussions.microsoft.com> wrote in message
> news:AE72C4F3-4EE6-47DD-B83C-AD8AF2A15A7D@microsoft.com...
> > Hi,
> >
> > I have a WB with 10 worksheets.
> > At the time I did this WB, I also created a Macro that had the task to
> > change the format of all the sheets.
> > Today, I have decided to hide some of the sheets and the macro does no
> > longer work.
> > I guess this is because it cannot find the sheets which are hidden.
> >
> > My question is: Is there a way to allow the Macro to work as before,
> > meaning
> > to continue changing the format of the hidden sheets as well?
> > Something like a condition that says, if Sheet XY is hidden then look for
> > it
> > into etc.
> >
> > Thank you
> > Alex
> >
>
>
>

Hi Alex.

Post the problematic code.


---
Regards,
Norman



"Metallo" <Metallo@discussions.microsoft.com> wrote in message
news:146507EB-FB5B-42EE-8E7C-B0A9AE032E9F@microsoft.com...
> Norman,
>
> I am aware that it cannot be selected, but my question was another, that
> is,
> is there a workaround to make the hidden sheets selectable even if they
> are
> hidden?
>
> For instance, the formulas work fine, the values generated as a result of
> a
> calculation turn out in the hidden sheets as if the they were unhidden,
> therefore I was wondering: If the formulas work on hidden sheets, why
> cannot
> the macros?
>
> Hope this is clearer.
>
> Thank you!
> Alex
>
> "Norman Jones" wrote:
>
>> Hi Alex,
>>
>> A hidden sheet cannot be selected, so try re-writing your code to remove
>> selections.
>>
>> If this does nor resolve your problem, post your code.
>>
>>
>> ---
>> Regards,
>> Norman
>>
>>
>> "Metallo" <Metallo@discussions.microsoft.com> wrote in message
>> news:AE72C4F3-4EE6-47DD-B83C-AD8AF2A15A7D@microsoft.com...
>> > Hi,
>> >
>> > I have a WB with 10 worksheets.
>> > At the time I did this WB, I also created a Macro that had the task to
>> > change the format of all the sheets.
>> > Today, I have decided to hide some of the sheets and the macro does no
>> > longer work.
>> > I guess this is because it cannot find the sheets which are hidden.
>> >
>> > My question is: Is there a way to allow the Macro to work as before,
>> > meaning
>> > to continue changing the format of the hidden sheets as well?
>> > Something like a condition that says, if Sheet XY is hidden then look
>> > for
>> > it
>> > into etc.
>> >
>> > Thank you
>> > Alex
>> >
>>
>>
>>