Hide Sheet

Posted by Gerard on April 01, 2001 10:56 AM

Hi all, I have a workbook that has several sheets. I use on e of them
for copying and pasting. I would like this sheet to be hidden at all
times. At the begining of my macro I set this sheet to Active because I
need it but if I set the sheet to Visible=False my macro fails. So is
there a way for me to hide the sheet but still use it?
Thanks

Posted by Dax on April 01, 2001 11:03 AM

You can copy, paste and do anything you want with a hidden sheet although you can't activate it without hiding it. E.g. this copies some data from Sheet 2 (visible) to Sheet3 (hidden).

Sub CopyPaste()
Sheets("sheet2").Range("a1:a6").Copy
Sheets("sheet3").Paste
End Sub

Regards,
Dax.