I have a workbook (ProtectedWorkbook.xlsx) that has a user interface page (UI Sheet), so when they enter a name, it displays some information on that person. It pulls this information from a hidden sheet (Data Sheet). Data Sheet's Visible property is set to "2 - xlSheetVeryHidden" and password protected. Additionally, the formula in UI Sheet that pulls in data from Data Sheet is hidden.
The problem is that even with all of this protection, a user can still click View Code on UI Sheet, see the name of Data Sheet, and then reference this from another (unprotected) workbook to extract all of the data from Data Sheet.
Is there anyway to prevent this?
Note: I cannot encrypt the workbook or make it read only because the user must be able to enter a person name in the one unlocked cell in UI Sheet.