Thank you for this tutorial. Is there anyway to do this but in a way that different users can see different tabs? For example, if the head of marketing logs in - they can see tabs 1 and 2, but if I log in I can see tab 3 only. I thought maybe I could hide the sheets and give each sheet a different password. But it doesn't seem like that's possible. Any suggestions?
If you’re using Excel Online or a cloud version (like Google Sheets), VBA won’t be available. You’d need the desktop version of Excel to work with macros.
Thank you so much for this tutorial. Is there a way to set the sheets in such a way, that an external user can see the different sheets at the bottom of the workbook, but when they want to click on the sheet, they cannot view it without inserting a password? Meaning, does the sheets have to be hidden and password protected OR can it just be password protected to restrict viewing....just so that I don't have to change the settings each time and unhide only certain sheets for each user that I have to send the document to. Hope this makes sense what I am asking.....
@mardeleenmuller8177 Yes it is possible to have all the sheets displayed and when someone clicks on a sheet's tab it pops up a password request. The only way I know to do this is using VBA - Excel's built in programming language
Hello and thank you for this information. I oversee a large department... I use M365 excel web version, which I share with my team through Microsoft Teams... I have a large document with a tab for each employee (47), the data in those tabs is displayed in a dashboard tab for the director to see the departments standing... I need to share the tabs with each individual employee along with the dashboard, but I need to prevent them to see any other employees information... #1. Would I be able to do this with the web version? #2. would I be able to accomplish any level of protection in the M365 excel web version? If not, #3. would I be able to set up the excel workbook through the desktop version, secure it (hidden sheets, password protection) and then upload to MS Teams to share with the team and allow every employee to see their tab while updating the data every month? Thank you...
@AbigailVillafane-y5p The only way to achieve what you want to do (hide the sheets and have them made visible only if the password is known) is using VBA, Excel's built in programming language. You'd have to write the VBA code using the Desktop version of Excel. The problem is that the web version does not support VBA (writing or running) which means if the file was opened in the web version the VBA code would not run. Even if you decided "OK to use this particular file we must use the Desktop version of Excel" this is not 100% foolproof. Anyone with the appropriate knowledge (and it's find-able online) would be able to crack the code and view the sheets the should not be viewing. Maybe look for a different solution, either not Excel-based or if you do want an Excel based solution consider having a separate file for each employee and combining the data into the dashboard from those files. If you want to discuss further drop me a message via theexceltrainer.co.uk/contact/
THis is exactly what i was looking for so many thanks.. However, a bit of feedback. You say "to change the property to xl very hidden for the sheet you don't want to hide". I think it is actually to make this change for the sheet you DO want to hide.
![[LIVE] : ONE ลุมพินี 89 | คู่เอก "ยอดไอคิว vs คิริลล์"](http://i.ytimg.com/vi/Z3vYkHJ_5Ig/mqdefault.jpg)
Thank you for this tutorial. Is there anyway to do this but in a way that different users can see different tabs? For example, if the head of marketing logs in - they can see tabs 1 and 2, but if I log in I can see tab 3 only. I thought maybe I could hide the sheets and give each sheet a different password. But it doesn't seem like that's possible. Any suggestions?
@amybobrow5222 I can only think of using a VBA-based solution to do this
Thanks for a swift user-friendly procedure. Mike, how can I implement the same solution Google Sheets?
@jovial3412 sorry I don't know. I'm not a Sheets expert
If you’re using Excel Online or a cloud version (like Google Sheets), VBA won’t be available. You’d need the desktop version of Excel to work with macros.
Just what I needed. Thanks.
Thank you so much for this tutorial. Is there a way to set the sheets in such a way, that an external user can see the different sheets at the bottom of the workbook, but when they want to click on the sheet, they cannot view it without inserting a password? Meaning, does the sheets have to be hidden and password protected OR can it just be password protected to restrict viewing....just so that I don't have to change the settings each time and unhide only certain sheets for each user that I have to send the document to. Hope this makes sense what I am asking.....
@mardeleenmuller8177 Yes it is possible to have all the sheets displayed and when someone clicks on a sheet's tab it pops up a password request. The only way I know to do this is using VBA - Excel's built in programming language
Hello and thank you for this information. I oversee a large department... I use M365 excel web version, which I share with my team through Microsoft Teams...
I have a large document with a tab for each employee (47), the data in those tabs is displayed in a dashboard tab for the director to see the departments standing... I need to share the tabs with each individual employee along with the dashboard, but I need to prevent them to see any other employees information... #1. Would I be able to do this with the web version? #2. would I be able to accomplish any level of protection in the M365 excel web version? If not, #3. would I be able to set up the excel workbook through the desktop version, secure it (hidden sheets, password protection) and then upload to MS Teams to share with the team and allow every employee to see their tab while updating the data every month?
Thank you...
@AbigailVillafane-y5p The only way to achieve what you want to do (hide the sheets and have them made visible only if the password is known) is using VBA, Excel's built in programming language. You'd have to write the VBA code using the Desktop version of Excel. The problem is that the web version does not support VBA (writing or running) which means if the file was opened in the web version the VBA code would not run. Even if you decided "OK to use this particular file we must use the Desktop version of Excel" this is not 100% foolproof. Anyone with the appropriate knowledge (and it's find-able online) would be able to crack the code and view the sheets the should not be viewing. Maybe look for a different solution, either not Excel-based or if you do want an Excel based solution consider having a separate file for each employee and combining the data into the dashboard from those files. If you want to discuss further drop me a message via theexceltrainer.co.uk/contact/
Thank you for the tutorial
i love you diction and tips , tkanks sir
THis is exactly what i was looking for so many thanks.. However, a bit of feedback. You say "to change the property to xl very hidden for the sheet you don't want to hide". I think it is actually to make this change for the sheet you DO want to hide.
@nickhills1 Thanks! And yes you are right. Don't know why I didn't spot that when I watched it back before publishing :-)
When I have this type of situation, I just copy the sheet(s) to share into a new file and send that.