You can access data without selecting the sheet, such as
Sheets("Sheet2").Range("B3").Copy

Jerry

"pywhacket" wrote:

Hi! I have macros that on a worksheet that run off data on worksheets, in the
same workbook, that need to be hidden when the workbook is distributed.
Whenever I hide them my macros Iget runtime error '1004' Select method of
worksheet class failed.

Is there a way around this?
Thanks -