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