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?
Bookmarks