help hiding tabs

[JasonLeVan]

I have a workbook with 100 tabs or so, and and i have macros writing data to different sheets all the time, but i dont want the user to see them, is there a way to hide them bu still access them for data to be written and read from, or do i have to hide and unhide them everytime i want to access them. seems there should be a way for them to just not be visable

 

[VoG]

You can hide them and still read from and write to them directly with code. You cannot select a hidden worksheet.