Selecting Invisible worksheets
Hi Ken,
A hidden sheet cannot be selected.
However, selections are rarely necessary or desirable. Most sheet
manipulation can be effected without unhiding or selecting the sheet.
If you experience any problem in rewriting your code to remove unnecessary
selections, post back with the relevant code.
---
Regards,
Norman
"Ken Soenen" wrote in message
...
Is there a way to keep a worksheet invisible yet be able to select it in
the code. I know I can set and use the cells on an invisible sheet, but it
doesn't appear that I can SELECT it [sheets("ratsafrats").select or
sheet4.select]. I have a number of sheets that will just be an annoyance
to the user but they are needed by the code(such as templates,
database,...).
Any thoughts would be appreciated.
ken
|