-
Sleeper: Unhide worksheet based on cell value
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
Last edited by Annabel; 07-19-2005 at 07:27 AM.
Reason: Missing attachment
-
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
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules