@AndrewI want to see if you can help with my issue. I've had essentially this exact code in a sheet I use but with an or function so the answer can be "yes" or "true". However, the sheet that is being hidden/unhidden sometimes re-hides itself for unknown reasons. It will unhide when I type yes, but when I go to use it later on it is hidden again, even though the cell value is still yes. Any idea why this might be happening, and/or how to fix it?

very to easy use

This doesn't work well when you have this formula on a few different sheets. You need to recalc sheet every time you activate it. 

有沒有在每一個標題前面插入分頁符號的功能？多謝

my inbox has disappeared

Hi, This post is very important information. I have learning more. I really enjoyed its reading this post enough to search for writing this excellent article and helpful post thanks for sharing. http://www.marketing-lists-direct.com

Thank you! You made my day! It solved my problem.

@Mark ReynoldsGreat solution, very useful! Thanks :)

Thanks for the solution. I am facing problem running this code. When i run the code, the code is loading and loading. There is nothing happen. What is the problem?