Forum Discussion
Celia_Alves
Jun 10, 2019MVP
Prevent access to table data on a workbook
Hello! I would like to provide a workbook to several team members with some data validation and vlookups that depend on data on a table. However, I do not want people to have access to the full tabl...
JKPieterse
Jun 11, 2019Silver Contributor
Hi Celia,
Your only really safe option is to make sure the table contains information the user in question is allowed to see. Any VBA savvy person will be able to get at the information one way or another. Worksheet protection and workbook protection are not enough either as both can very easily be broken into. I'd suggest placing the data in a database with proper row-level security and user roles setup and then create a connection to that table which refreshes on file open.
Your only really safe option is to make sure the table contains information the user in question is allowed to see. Any VBA savvy person will be able to get at the information one way or another. Worksheet protection and workbook protection are not enough either as both can very easily be broken into. I'd suggest placing the data in a database with proper row-level security and user roles setup and then create a connection to that table which refreshes on file open.