View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default 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