Hide and Unhide sheet

Need some help please (I'm not a programmer)

I have a drop list on a worksheet. I need to hide certain worksheet (say worksheet B and C) when the second item in the drop list is selected (let say that second item is = 2).
Lets say the number of worksheets are A -- F
Otherwise all sheets must be visible.

The macro on my worksheet is

Please Login or Register  to view this content.

The sub-routine being called are: ....

Please Login or Register  to view this content.

I am getting errors that I can't figure out -

When you post code please enclose your macro code in code tags - please see our forum rules http://www.excelforum.com/forum-rule...rum-rules.html - Rule 3 will show you how to do this.
The problem with the posted code is that there is no macro called SHORTMacro (unless you did not post that part of the code) - your macro will error out with "Sub or Function Not Defined" - is that the error you are getting?
Just to shorten your code there is very little need to ever Select or Activate sheets - just use referencing e.g.

Please Login or Register  to view this content.

As the code is probably in Sheet A then there is no need to select sheet A as doing it this way Sheet A will remain the active sheet.
Make sure with your code at least ONE sheet is visible.
If that is not the error then please post a sample workbook with your code - make sure there is no sensitive/private data in the posted dummy workbook

Hi svirgo

Welcome to the Forum!

As smuzoen has suggested, you MUST wrap your code in code tags. This is not optional.
Please Edit your post #1 to include code tags.
To edit your post, press Edit Post, press Go Advanced to see the [#] button). Highlight your code then press the [#] button. Press Save Changes. The result will appear like this in the post window:

Please Login or Register  to view this content.

You probably should not anticipate response until you've done so.

Hi svirgo

No apology necessary. Thanks.

You just need to reference the named range in the worksheet change event. Change your code to

Please Login or Register  to view this content.