PDA

View Full Version : Sleeper: Unhide worksheet based on cell value



Annabel
07-19-2005, 05:31 AM
Hi All
I have a workbook with several sheets. The first sheet have combo boxes with pass values to hidden fields on sheet 2.

On sheet two these values pass text (Yes for 1, No for 2) to a column of fields.

Ideally where the field is Yes (value 1) I would like sheet three to become unhidden. This will need to be repeated for each of the cell in the range that have text of YES.

Can anybody help. I've attempted to create a macro but with little success as I'm not very good in VB and don't know how to trigger the event.

I've attached the workbook in case that helps
Thanks
Annabel

mdmackillop
07-19-2005, 05:38 AM
Hi Annabel,
Welcome to VBAX.
Your file did not attach. You can attach either Zip files, JPGs and a couple of others. Excel requires to be zipped.
Regards
MD