LinkBack URL
About LinkBacks
Is there a way in an Excel 2013 workbook to allow some users access to certain sheets (say Sheets 1-3) while other users only have access to the Sheets 4-6 then the administrator has access to all Sheets?
Thanks for your help.
RR
Is there a way in an Excel 2013 workbook to allow some users access to certain sheets (say Sheets 1-3) while other users only have access to the Sheets 4-6 then the administrator has access to all Sheets?
Thanks for your help.
RR
You can protect each sheet with it's own password and then give password as you like.
Never use Merged Cells in Excel
If I password protect a sheet doesn't it just protect what they can do on it? I want to hide one sheet from user A and a second sheet from user B since they have different pricing structures. So can I do that?
You can make sheets visible (xlSheetVisible), hidden (xlSheetHidden) and very hidden (xlSheetVeryHidden).
The property xlSheetHidden hides the sheet, but it can be made visible by any user through the Excel user interface.
If you use xlSheetVeryHidden, however, the user cannot make the sheet visible through the Excel user interface.
So create Main sheet (that will always be visible).
And there add buttons for each sheet that will launch prompt question or userform where you can enter password.
In module add all passwords like this:
And in code allow those passwords for each sheet.
Please Login or Register to view this content.
Something like (example for userform)
At the end protect VB Project so other users cannot see or edit module with passwords.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks