Trouble unhiding a password protected worksheet in excel 2010 vba

Hi Everyone -
I have a Workbook with several Hidden Worksheets. All of the Worksheets are password protected.

Problem - I want to copy data from a visible worksheet to a hidden worksheet. I am using the following code:

Please Login or Register  to view this content.

I get Run-time Error 1004 - Unable to set the Visible Proerty of the Worksheet

Any help is greatly appreciated

Jim

Thanks Wallyeye

That seemes to work but blow up when I execute the rest of my code

Please Login or Register  to view this content.

you can't select an inactive sheet but you don't need to

Please Login or Register  to view this content.

will do the job of

Please Login or Register  to view this content.