In Sheet1 cell A1 enter a value say 10,,and from Sheet2 try a formula
=Sheet1!A1+A1 after hidding sheet1. The formula should add the value of
hidden sheet A1 + sheet2 A1....Is this what you mean?

If this post helps click Yes
---------------
Jacob Skaria


"Soccerboy83" wrote:

How can i accomplish this?

"Mike H" wrote:

Hi,

Yes you can still read values from hidden sheets and use those values in a
calculation and you can write to hidden sheets with code.

Mike

"Soccerboy83" wrote:

Is it possible to hide the worksheets within a workbook, and still have the
workbook calculate formulas based off of the hidden worksheets. The reason i
ask is i have alot of information within the spreadsheet that i do not really
need at this time, and i would like to hide it so that it makes it easier to
navigate through the workbook.