Double protecting sheet/cells

[cadustin]

I have a workbook with several tabs. Each tab is password protected to avoid supervisors from editing any cell they are not allowed to. I'd also like to protect the other tabs from being viewed by other supervisors so this can be a shared workbook. Is this possible?

Edit:
Sorry, need to add a little more explanation. I have a Manager tab that is a summary tab of all of their supervisors, which have their own tab. Each tab has data that the supervisor needs to enter information on but because of the formulas, they only have access to certain cells in their sheet. Since there are other supervisors, the manager does not want them to see the data entered by other supervisors, so I need to make it where the supervisor can only see his/her tab as well as keep the current cells locked. Thanks

 

[Candyman8019]

This is possible and there are several threads on this board about it. Long story short...nothing in Excel can be kept from someone who knows what they're doing...but for general users this can be accomplished.
Here's a little something that I've been working on.

OneDrive

Sign in to your OneDrive cloud storage and Office Online.

1drv.ms

This sheet will require users to log in and only see specific sheets. It is partially based on concepts from others…then I took it a few steps further.

Some of the features include:

• It will default to the username of whoever is logged into the computer.
• Users are allowed 3 attempts to log in before the app closes.
• Users cannot close out of the login form.
• Users and administrators can be defined within the application.
• Users and administrators can change their passwords for the apps.
  • Passwords can be alphanumeric. No other restrictions have been put in place.
• Successful logins are tracked for audit purposes.
• Logged in user is shown in the status bar.
• Administrators define which tabs a user can see. The rest are automatically hidden.
  • This is currently set to allow up to 6 sheets for each user.
• As new tabs are added (or names changed), an administrator can trigger an update to the data validations used for allowing users to see specific tabs. Alternatively, it will update the next time the sheet is opened.
• Users will not be able to unhide sheets on their own. They will only see what the admin allows them to see
• ‘SaveAs’ is only allowed for Admins. Users can only save.
• The VBProject is locked.
• There is a recovery feature where if the admins forget their password, they can still log into the app to update passwords, edit the workbook and get the password for the VB project.
• Upon closing the app, all tabs are hidden to get ready for the next user to open the app and log in.
  • In case the app crashes before tabs are hidden, they will also be hidden upon opening the sheet.

As you're using it, if you think of other useful features, I'd love to hear about them to create the next iteration of this.

 

[Candyman8019]

Initially, you can log in with: joe / 9999

Recovery userID and password is:
superadmin
LetMeIn11!
I suggest you log in with this at least once and change the password on the recovery tab.

 

[cadustin]

This is possible and there are several threads on this board about it. Long story short...nothing in Excel can be kept from someone who knows what they're doing...but for general users this can be accomplished.
Here's a little something that I've been working on.

OneDrive

Sign in to your OneDrive cloud storage and Office Online.

1drv.ms

This sheet will require users to log in and only see specific sheets. It is partially based on concepts from others…then I took it a few steps further.

Some of the features include:

• It will default to the username of whoever is logged into the computer.
• Users are allowed 3 attempts to log in before the app closes.
• Users cannot close out of the login form.
• Users and administrators can be defined within the application.
• Users and administrators can change their passwords for the apps.
  • Passwords can be alphanumeric. No other restrictions have been put in place.
• Successful logins are tracked for audit purposes.
• Logged in user is shown in the status bar.
• Administrators define which tabs a user can see. The rest are automatically hidden.
  • This is currently set to allow up to 6 sheets for each user.
• As new tabs are added (or names changed), an administrator can trigger an update to the data validations used for allowing users to see specific tabs. Alternatively, it will update the next time the sheet is opened.
• Users will not be able to unhide sheets on their own. They will only see what the admin allows them to see
• ‘SaveAs’ is only allowed for Admins. Users can only save.
• The VBProject is locked.
• There is a recovery feature where if the admins forget their password, they can still log into the app to update passwords, edit the workbook and get the password for the VB project.
• Upon closing the app, all tabs are hidden to get ready for the next user to open the app and log in.
  • In case the app crashes before tabs are hidden, they will also be hidden upon opening the sheet.

As you're using it, if you think of other useful features, I'd love to hear about them to create the next iteration of this.

Sorry Candyman, but this doesn't help me right now. I realize you are working on something, but unfortunately, I need to figure this out now. And I have been looking before I posted about this and cannot find anything that tells me how to do this. Thanks

 

[Candyman8019]

You can use this as a template and add whatever tabs in that you want

 

[Candyman8019]

There is a lot involved in what you're trying to do. Providing instruction would be a lengthy time commitment...having this as a template really simplifies things for you.

 

[cadustin]

There is a lot involved in what you're trying to do. Providing instruction would be a lengthy time commitment...having this as a template really simplifies things for you.

I already have all of my spreadsheets created. That would be over 20 new spreadsheets not including each tab. Thanks, but this would be too time-consuming.