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?
|