Hi
We have a shared workbook but only 2 people should be allowed to edit it......its very annoying when someone goes in with full control and not read only. Is there anyway to force read only based on username? e.g if user is Tom, the workbook will open as read only but if user is Mike then it will open with full access?
I know you can suggest read only, but ideally i would like a bit of code to force it.
Cheers
Graham
We have a shared workbook but only 2 people should be allowed to edit it......its very annoying when someone goes in with full control and not read only. Is there anyway to force read only based on username? e.g if user is Tom, the workbook will open as read only but if user is Mike then it will open with full access?
I know you can suggest read only, but ideally i would like a bit of code to force it.
Cheers
Graham