Do you mean hidden, or is the workbook  just not visible (i.e. obscured)? There
is a big difference.

You don't seem to be able to copy  a hidden  sheet to the clipboard, although you
can copy selected ranges of a hidden sheet  to the clipboard. You can, of
course, copy an obscured sheet to the clipboard.

What does your code look like?