I have a spreadsheet with about 8 worksheets that when complete I have to individually send out each worksheet. I want to have 1 main worksheet and create a links on the one sheet to the others but I want the other 7 sheets hidden from view. I know I can hide the sheets using the xlsSheetVeryHidden through VBA but once it's hidden I can't do a link to the sheets because it's hidden. Any help would be appreciated. Thanks
Bookmarks