Auto hide worksheets from cell data input.

Hi All
I’m after a way to auto hide a single worksheet (ExVal1) once either of two cells (H78 or I78) within that sheet has a value greater than 0. I would prefer the sheet to be hidden on the next opening of the workbook itself.
I have two systems, one running excel 2003, the other 2007, I need this to work on both systems
I’ve searched the forum for a number of hours and found a multitude of almost close answers but the VBA formulas are so different I get lost. I’m new to Excel but learning fast and VBA is an area in which I wish to develop.

Can anyone help?

Regs
Al Z

Welcome to the forum.

Please take a few moments to read the forum rules and then modify your thread title.

It is often the case that a sample workbook will help clarify your requirement, for example the structure of the workbook, which sheet to be hidden, which sheet contains the cells to be checked, and so on.

It sounds as though you require a Workbook Open event which will check the two cells and, if the criterion is met, will hide the sheet. You must have at least one sheet visible.

Regards

Hello all

OK, post name amended! Sorry members, please feel free to dis the new guy I was in such a flap last night.
dangelo, I've used the code but initially the sheet was still visible, I did notice a warning at the top of the page stating that macros was not enabled. I opened the warning and enabled macros and the sheet instantly hid, great. Is there a way though to keep macros enabled all the time or can it be asked before the workbook is opened? I've now progressed and added another 11 sheets (ExVal2-ExVal12). How do I adjust the code some the same criteria is valid for each sheet? I do have a master sheet still visible (Course Details). I would like the workbook to always open on the Course details worksheet also?

Thanks for the guidance to all partaking in my project.

Regs
AlZ

Ladies & Gents

That’s the one, I've managed to get the item to open on the correct sheet also, thanks for all your help. You are all very knowledgeable.

Regs

AlZ