I'm having a problem where users are able to enter the name of a hidden sheet and point to a cell to make hidden data visible on a sheet with unlocked cells. Is it possible to prevent this? I thought hiding it would do the trick, but I guess not.
For example, I have three worksheets: Summary, East, and West. I hide West because it has salary information for particular employees. When I type any kind of cell reference into Summary that points to the hidden West sheet (e.g., =West!A1, =West!A2), that data appears in the sheet, which allows users to see other people's salary information.
Any help would be greatly appreciated.
Bookmarks