Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
Is there anyway to restrict the info shown on a excel book depending on the user/password programmed?
I have a large database on my company and i want to restrict the Information shown on the excel file to some people. Is any way to do that?
3 Answers
- Anonymous1 decade agoFavorite Answer
There is no built functions in excel to restrict the information you show.
You could use access security to restrict who can see the entire spreadsheet.
Or, you could write a set of macros that populates the data when the file is opened, based on the user information. That would not be trivial.
- Anonymous1 decade ago
Are you working on a server where users have their own log ins? If so you can share the workbook with selected users and also protect against unauthorised opening or editing by others.
