Restricting Access

Hello All,

I have an excel workbook that is shared across multiple users. Is there a way to assign multiple levels of security to specific people. There should be three "levels" of access. I, as the creator and monitor, need access to everything. A single person (let's call them "Bob") need to be able to input data in specific columns and press an interactive button. A group of people need to be able to view the workbook and use the Find tool to search the document for specific information. However, they should not be able to edit ANYTHING in the workbook or use any of its functions.

Is this possible? Any guidance would be greatly appreciated!!

Thank you,

-K

Excel is limited in its security implementation. Here's what it can do.

For what you want to do, you're probably better off using a database if you want role based access. You could use a SQL back end, tie it in to your network authentication, and then configure a connector for Excel to get data. You could use MSSQL or other similar databases such as MySQL or PostgreSQL (those are the top 3). MSSQL has a free developer version whereas MySQL and PostgreSQL have paid and community editions.