I have a user you needs to share a spreadsheet with a few users but wants to prevent other users from viewing the data and for those that can view it, prevent them from changing the data. I would like to set up the sreadsheet with a main sheet that has a button for each year that they wish to view data for (ie. '2004', '2005')when they click the button, it would ask for user name & password. I would like it to either deny access, allow viewing or allow full access depending on what username & password they enter. I would then like it to go to the appropriate sheet and display the data. I would like to have the data sheets hidden so that unauthorized users not be able to access the sheets by accident or know they exist. Is this possible and no it cannot be set up in another program as this is all the user is familiar with. Any help would be appreciated.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Excel Prevent Access to Data
- Thread starter kmvargo
- Start date
Similar threads
- Locked
- Solved
- Locked
- Question
- Locked
- Question