Hi
in most cases you don't need to select a sheet. Something
like the following works also for hidden sheets:
sub foo()
dim wks as worksheet
set wks = worksheets ("Sheetxxx")
msgbox wks.range("A1").value
end sub

-----Original Message-----
Hi.

I am designing a workbook in Excel 2002, using VBA6, and
i have made a
worksheet that contains references and sourcematerial I
don't want the
user to see. But when I hid the document, I found that
the
sheet(xxx).select function no longer worked.

Help?


---
Message posted from http://www.ExcelForum.com/

.