Hi

Both code snippets below work with sheet RelationalData hidden or even very
hidden:

....
ReadValue=ThisWorkbook.Sheets("RelationalData").Ra nge("A1").Value
....
ActiveSheet.Range("A1").Value=ThisWorkbook.Sheets( "RelationalData").Range("A1").Value


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )


"gti_jobert" wrote
in message ...

Hi all,

I have a sheet that contains all the data for the app, is it possible
to have this sheet hidden but still be able to select the data from it
using vb code?

When i do hide the sheet and use the select code;


Code:
--------------------

Sheets("RelationalData").Select

--------------------


It produces an error - "Select Method of Worksheet Class Failed"

Any suggestions?


--
gti_jobert
------------------------------------------------------------------------
gti_jobert's Profile:
http://www.excelforum.com/member.php...o&userid=30634
View this thread: http://www.excelforum.com/showthread...hreadid=511699