Hidden sheet not unhiding

[mbono1]

Good morning all,

I have a slight problem, that I need help with. I have a workbook with data validation, which refers to named ranges for drop down lists on a hidden sheet. However, the sheet will not unhide through the normal way, Format/Sheet/Unhide, nor will it unhide through Visual Basic Editor. The drop down lists all work, however I need to amend them and this is causing a bit of a problem.

Any idea's?

Thanks

 

[agihcam]

try;

sheets("yoursheetname").visible=true