Hide sheets based on condition

[pauldaddyadams]

Hi,

I have a user sheet in which the user can select a region (North, East, South and West).

Based upon the selection I need a macro which will hide all the other sheets other than the users selection. E.g. If the user selects “North” then all the sheets with “North” Cell A1 will remain visable.

Can this be done?

[HaHoBe]

Hi, pauldaddyadams,

maybe like this.

Into ThisWorkbook:

Please Login or Register  to view this content.

Behind Sheet1:

Please Login or Register  to view this content.

In a standard module;

Please Login or Register  to view this content.

Ciao,
Holger

[jraj1106]

Hi.

You can try this too:

Example.xlsm

[hafizimran]

Please Login or Register  to view this content.

[pauldaddyadams]

Hi,

I need to access the sheets however they are hidden - is there a macro that will unhide all?

Also, what part of the code is telling excel to look at cell A1 on each of the individual sheets as I may need to change this cell

[HaHoBe]

Hi, pauldaddyadams,

any changes can be made by VBA to sheets which are very hidden.

Please Login or Register  to view this content.

Ciao,
Holger

[pauldaddyadams]

Wow - so many helpful replys!!

Thank you all! I have managed to get this to work!