Sharing Worksheets and keep control

Copper Contributor

I need to share a worksheet with my team. However I am the ONLY one that needs to be able to add clients, rows, and be able to utilize the autofilter, I have tried all the steps I know and they are still able to use these options. When I change it I can not use the features. I basically need full control and they need to be able to enter info ONLY in a specific area. I have been working on this for 2 days and im about ready to pull out my h

2 Replies

@Abiola1  Thank you. I have already tried these steps and though it doesn't allow others to change those areas, it also will not allow me to utilize the autofilter, add rows, etc. In order for me to be able to update the sheet I have to unprotect it first?