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.

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.

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.

If you're writing a macro, there are not many things that you do that need to
have the sheet visible.

Dim myCell as range
set mycell = worksheets("hidden").range("A1")

if isnumeric(mycell.value) then
mycell.value = mycell.value + 1
end if

This kind of code won't care.

And if you're doing some calculations, you can use a formula like:

=hidden!a1+hidden!c9

And the formula won't care if that sheet named Hidden is visible or not.

And in xl2003 menus, I can hide a sheet by:
Selecting the sheet(s)
Format|sheet|Hide

And unhide them the same way
format|sheet|unhide
(a single sheet at a time)

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.

--

Dave Peterson

Excel 2007: Home tabCells groupFormatHide & UnhideHide Sheet

Francis Hayes
www.TheExcelAddict.com

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.