Macros - Unhide and hide

[Guest]

Hi,

I'm a novice at using excel and I'm trying to create a macro that will;

When the worksheet is opened, an option can be selected (ticked).....that
will unhide all rows that have a certain value in column 'A'.

Then when this option is selected on again (unticked), it will hide rows
that have a certain value in column 'A'.

 

[Don Guillett]

from a post of mine just today. Was it you?

 

[Guest]

Don....

Nop..no not me not I.

Thnx 4 your speedy reply....I'm really green when it comes 2 macros.
I tried your suggestion..but alas, it does nothing...I'm obviously not
executing something correctly..

The rows that require to be unhidden and then hidden...
have the value in column A that = calendar.

This would be facilitated by a box within the worksheet, for which the macro
will be assigned

once this box is selected, it would unhide all rows that have the value of =
calendar in column a.

when this box is selected again, it would hide the associated rows.

can this be done?

anXiously awaiting reply