can vba read hidden sheets?
When a sheet is Very Hidden, not only is it not visible in your list of sheets, it's also not shown in the list of sheets when you click on “Unhide”. Very hidden indeed! The only way to access a Very Hidden sheet is to go into the VBA Editor (Alt + F11).