Compile Error in Hidden Sheet

Hi All.

I've written some VB code in Excel 2003 which hides and unhides worksheets dependant upon 'Yes' or 'No' in a named range. This works Ok in Excel 2003, however if I try and use it in Excel 2007 it shows error 'Compile Error in Hidden Sheet'. When I debug it the error 'Compile Error - Method or Data Member Not Found' appears. The code in question is as follows:

Please Login or Register  to view this content.

This code is repeated for other worksheets, and VB highlights the line section 'Range("Email_Check")' as being the problem. Any help greatly appreciated.

Simon

Have you checked whether named ranges eg. Email_Check exist ...

May be you have created manually in 2003.. but you forgot to create it in 2007

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

I will add them this time.

Your code naming is confusing.

You use cell in the for next, but don't declare it as a variable.
Is Email_Cell a range of cells?
You dim Email_Check but don't set it.

Your code appears to loop through a range of cells hiding/unhiding the same sheet.

I still don't see why you are looping through a range & opening/closing the same sheet