Re: Trouble with copy of xlSheetVeryHidden

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance


Tim,
Thanks for the reply. But I'm confused. My code shows a Period before
Copy. Did I misunderstand your post?
Maybe I was too cryptic in my first explaination.
I'm using a hidden *** as a "template" that is copied and made
visable as a new work***.
The code works fine as long as the CopySht is only hidden, however when
the CopySht's property is set to xlVeryHidden the code no longer works
and give the error message found in my original post.
Thanks again for your help.


--
Casey


------------------------------------------------------------------------
Casey's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=4545
View this thread: http://www.excelforum.com/showthread.php?threadid=395158

.

Quantcast