Hi
I have a workbook with multiple sheets that I intend to put on a public server at work. However, I only want certain sheets to be accessible to certain users. Obviously, the ones I want no-one to see can be hidden, but of those remaining, I want some people to have write access on some of the remaining sheets, and other to only have read/edit access to the ones that are left.
Can this be done?? I've set the protection up as best I can, but the standard features don't seem to cover this type of protection.
Thanks
Jim
I have a workbook with multiple sheets that I intend to put on a public server at work. However, I only want certain sheets to be accessible to certain users. Obviously, the ones I want no-one to see can be hidden, but of those remaining, I want some people to have write access on some of the remaining sheets, and other to only have read/edit access to the ones that are left.
Can this be done?? I've set the protection up as best I can, but the standard features don't seem to cover this type of protection.
Thanks
Jim
