Macros - Unhide and hide

  • Thread starter Thread starter Guest
  • Start date Start date
G

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

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
 
Back
Top