Basically I have a workbook with three sheets, for one group of people who will be editing the sheets constantly throughout the day; i want them to have full access. But another only needs to see the last sheet (sheet3). I've played around with protecting and unprotecting but this would be a hassle for the folks who have to work with the sheet all day. So i'm thinking that the best way would be to have a new workbook that will link back to the original workbook and either link to just the worksheet i want or link to all three, but we'll protect the new one so it will only display the one we want it to. But i can't figure out how to link to an entire sheet or workbook. Can this be done, or is there a better option?
Thanks
Andy




Reply With Quote