View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
gti_jobert
 
Posts: n/a
Default Hidden Worksheet


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