View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default referencing hidden sheets

mohsen,
If you think about it, that makes sense. If an object is hidden, it cannot
be selected.
Most of Excel's functionality does not require you to select an object.
Obviously you cannot then use Selection, but change these to their Excel
objects.

NickHK

"mohsen" wrote in message
...
Hi, I have three sheets that I do some calculations in. I wrote a form
which provides a single input place for all of the sheets, but I cannot
hide my sheets. Everytime I hide them, so the user only sees the form,
the "sheet (x).select" will cause a compile error because it cannot find
the hidden sheet. Any suggestions, please?