Hi all,
I've created a sheet with employee data that needs to be auto-filtered
according to employee managers, then those rows for the employees need to be
e-mailed to their respective mangers. Problem I'm getting is that we don't
want manager A to be able to see manager B's employee data.They do however
have the ability to unhide by opening in excel. And, the program won't allow
me to e-mail a protected sheet, so I can't do that. I'm thinking there's got
to be a way to do this other than copying and pasting the appropriate cells
into outlook messages for each manager.
Anyone have any ideas?
Thanks
Colin