Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA code to Add data to exsiting worksheet | Excel Discussion (Misc queries) | |||
advanced: synchronizing data value across two worksheet drop boxes | Excel Worksheet Functions | |||
Accessign formula's in worksheet that appear to have been hidden | Excel Discussion (Misc queries) | |||
Copy without Hidden Cols - How | Excel Discussion (Misc queries) | |||
copyright and worksheet protection | Excel Discussion (Misc queries) |