Help! Calling hidden sheets?
 

Gary,

You can't activate or select a hidden sheet.
You can however load variables in your VB code with the contents of a cell
from a hidden sheet or put values (or even formula's) in the cells

Sub AAA()
A = Worksheets("abc").Cells(1, 10).Value
Worksheets("abc").Cells(1,1).Value =100
Worksheets("abc").Cells(2,1).Formula = = "=SUM(A1,J1)"
End Sub

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *

"Gary" wrote in message
...
I have several modules that call on sheets to perform calculations.
Everything works fine, but when I hide the sheets, the program crashes as it
cannot find the sheet to be called. Is there any way to call 'hidden
sheets?

Syntax used to call worksheets a
1. Worksheets("abc").Activate
2. Sheets("abc").Select

Thanks to all.