Selecting a sheet from a range - issue with hidden sheets.

**Barking_Mad** · 05-07-2013, 10:55 AM

Hi,

I have the below code that selects the sheet from a dropdown list box as selected by the user. How can I modify it so that it unhides hidden sheets first - as at present im just getting an error if the selected sheet is hidden.

Please Login or Register  to view this content.

**Mumps1** · 05-07-2013, 11:03 AM

Try;

Please Login or Register  to view this content.

**Barking_Mad** · 05-08-2013, 04:41 AM

Thanks. What difference to the code does Intersect make?

**JasperD** · 05-08-2013, 05:06 AM

Intersect doesn't really make a difference to your code, but it's easier to use if you want to check a range of cells rather than one cell in particular.
When working with worksheet_change macros, it's better to get used to applying intersect, even if it's just one cell you're checking.
That's all

**Mumps1** · 05-08-2013, 09:38 AM

Just to add to what JasperD has stated ... When using a Worksheet_Change event, 'Target' refers to the active cell. The use on 'Intersect' restricts the 'Target' to the range, in this case E10. What this means is that if you select any other cell outside of the described range, the macro will terminate. The 'Target' in your case will always be the value of E10. I hope this helps.