thegreencar
New Member
- Joined
- Feb 8, 2016
- Messages
- 34
Hi,
I have a file which will be distributed to various depts which contains only a few columns of sensitive information.
I need to hide these columns but also allow that the entire sheet be pasted over, as this file will be updated monthly.
The team updating this particular sheet are not excel savvy so I'm hoping to do this as automated as possible.
E.g.
Team is pasting information to entire sheet - Column A-Z, but I need to keep columns C-E hidden from other teams. Is it possible to do this without needing to protect & unprotect the sheet every time? I'm not confident that the team inputting will hide and protect every time.
I was thinking something like grouping the sensitive columns and password protecting the option to ungroup them but I'm not able to figure this out.
Appreciate and help you can offer.
Thanks,
C
I have a file which will be distributed to various depts which contains only a few columns of sensitive information.
I need to hide these columns but also allow that the entire sheet be pasted over, as this file will be updated monthly.
The team updating this particular sheet are not excel savvy so I'm hoping to do this as automated as possible.
E.g.
Team is pasting information to entire sheet - Column A-Z, but I need to keep columns C-E hidden from other teams. Is it possible to do this without needing to protect & unprotect the sheet every time? I'm not confident that the team inputting will hide and protect every time.
I was thinking something like grouping the sensitive columns and password protecting the option to ungroup them but I'm not able to figure this out.
Appreciate and help you can offer.
Thanks,
C
