Check Box - (Hide / Unhide worksheet)

[batchy]

Hi,

I have 2 worksheets (January & February).

If you check the box "Show February", i would like to do the following actions:

*Un tick the "Show February" then hide the "January" tab and unhide the "February" tab and select cell A1.

Attached is a sample file.

[Fotis1991]

Something like this?(for the first part). If yes we'll do the other one too.

Please Login or Register  to view this content.

[batchy]

Ive tried the following:

Please Login or Register  to view this content.

How do i add uncheck the box once the above action has been completed?

[Fotis1991]

This is my best.

Please Login or Register  to view this content.

[batchy]

I have resolved this by doing the following:

Please Login or Register  to view this content.

[Fotis1991]

Well done!

thanks for the feed back.

As that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED,as per Forum Rule #9. Thank you.

Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.