Hide Worksheets when a single cell changes from 1 to 0, Unhide when value changes to 1

Hey Everyone,

I am very rusty 5 years since I have written vba.

I have workbook with 25 worksheets and I only want to show each worksheet where a 1 is populated in the summary sheet in a specified cell and for this to happen automatically when the cell value is entered by the user.

I have written the following code and it compiles but does nothing.

In this example the cell is A2, the summary sheet is List of Goals and the sheet to be hidden is Accomodation.

Any help appreciated.

Please Login or Register  to view this content.

Moderator'note: You have to put code tags around your code. Select the code then hit the "#" sign.

It will work quite well if you create an Event in the specific sheet where the cells will contain the information. pretty much like this:

Please Login or Register  to view this content.

This event "Worksheet_Change" run your macro whenever a cell is changed in THAT sheet. That is exactly what you want.
Good luck