A constant question we have received from our customers and users of our excel forum é How to restrict access to a worksheet's tabs?
We have already developed excel spreadsheets for several years now. The official dates vary between 2011 and 2013, but anyway, much water has already passed from below that bridge. We start with only 3 spreadsheets and today we have hundreds of products that help the increasingly specific and interesting needs!
However, we always wonder how to make our worksheets easier to use and more powerful. Therefore, over the years we have advanced our studies in usability and also of Excel itself, fact that made us launch our own courses.
We recently decided to venture into a new area that can completely change how our spreadsheets are used: the development of macros. These are VBA codes that allow spreadsheets to perform typically software-only functions.
A recurring request from our customers was what could create different users for a spreadsheet and that they only have access to some areas of the spreadsheet. This is an amazing feature that can be used in any spreadsheet and make the use of it more specific. So, I'll show below how we set up this macro that is now for sale on the site!
1. Login when you open the worksheet
When you use our macro in your spreadsheet, every time you open it, you will need to log in. Of course, each level of access will see different tabs open!
2. User Creation and Levels of Access
Logging in with an administrator account, you will be able to see all the tabs of your spreadsheet, view all registered users and also the different levels of access programmed.
And that's it! It's pretty simple, right? But make a big difference for anyone who is working with sensitive data like project budgets, salaries or employee performance appraisal! See our video tutorial below:
Did you like the post? Buy this one macro already ready for use of user creation and access level!