Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,123
Default Help! Calling hidden sheets?

Hi Gary

If you want to select it you must unhide it.
But for most things you don't have to select the sheet

example to copy to the hidden sheet

Selection.Copy Sheets("abc").Range("a1")


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"Gary" wrote in message ...
I have several modules that call on sheets to perform calculations. Everything works fine, but when I hide the sheets, the

program crashes as it cannot find the sheet to be called. Is there any way to call 'hidden sheets?

Syntax used to call worksheets a
1. Worksheets("abc").Activate
2. Sheets("abc").Select

Thanks to all.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
hidden sheets Soccerboy83 Excel Discussion (Misc queries) 5 November 25th 09 06:17 PM
Calling cell values from random sheets from a base sheet [email protected] Excel Worksheet Functions 2 January 19th 07 08:21 PM
How do i reveal hidden sheets surreyjed Excel Discussion (Misc queries) 3 September 4th 06 06:50 PM
Hidden Sheets QUESTION-MARK Excel Worksheet Functions 4 May 19th 06 07:06 PM
Operating on hidden sheets Hari Prasadh Excel Discussion (Misc queries) 2 January 28th 05 08:33 AM


All times are GMT +1. The time now is 08:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"