👉 Up4Excel Downloads Library: »» ml.up4excel.com/library ✅ FREE Access to ALL Up4Excel Files. Includes Excel Templates, Training Workbooks, Example Data, Cheat Sheets and more. New Content Added Weekly!
🎯 Prevent users accessing your hidden Excel sheets. Stop someone seeing it at all….they won't even know it exists! Hide anything you want on it like passwords, user data, usage data etc.
however, there are also tutorial videos on how to see very hidden sheets and the problem becomes simply a few more clicks, but in the end the "hidden sheet" is not so protected. How can you put a password for accessing only a sheet? Thank you
@@catalin.ardeleanu Have a look at this quick tip to password protect the code to unhide the very hidden sheets ruclips.net/video/hF47KOvpK68/видео.html . Of course someone very determined could then also crack that password with software but I guess you can't 100% protect any file really.
Is there anyway of preventing users from doing the same and changing it from "very hidden" to "visibile" if they know this trick? Like adding a password?
Yes, you could protect the VBA Project with a password so they can't access the property and therefore can't change it. See this video ruclips.net/video/hF47KOvpK68/видео.html 👍
You could just link some code to a button that requests the password, and if they type in the correct one unhide the sheet. You can search this on the web as too much to go into here but essentially it needs a message box inside an if statement 👍
It is certainly possible but it's a lot of set-up. You either need people to log into your spreadsheet using a user form, or detect their windows username. Once you know whose in the spreadsheet you could hide or reveal sheets accordingly. Note you would need to ensure macros are enabled to make this all happen. See ruclips.net/video/XXbsJRWeLTY/видео.html for this bit
Thanks for your video. However, I notice that we could able to view those hidden sheets by uploading to Google sheet. How to prevent users to view those hidden sheet by this trick (uploading to Google Sheet)?
I am using excel file that is saved on OneDrive and shared with few people. Is there possibility to hide some sheets from specific people, and on same time same sheet should be visible for others?
Now you're asking! YES you can, but you will need to detect the user and then run code to hide or unhide sheets depending on what you detect. Too much to explain everything in writing, but using this code line "Set objNet = CreateObject("WScript.NetWork") " then this code "sUser = objNet.UserName" will set sUser to the windows logon name of whoever just opened the spreadsheet. Then use the techniques of method 3 in this video ruclips.net/video/XXbsJRWeLTY/видео.html to force macros on, and detect if the user is someone you want to hide or unhide sheets for. Good luck. Might make a video on it one day.
@@Up4Excel Thanks a lot for your replay! Now, I'll try to figure it out what you wrote :) Might subscribe to your channel one day :) when you make a video on this topoc Have nice day
@@Up4Excel I figure out some parts (objNet, sUser)😁. Scenario: - *my windows log name is admin* and _it shows all sheets (for example: sheet1, sheet2, sheet3, ... sheet7)_ - *others windows log name is regular user* and _if shows just one/few sheet (for example: sheet3)_ - same excel file has been opened on few users and it is ready for collaboration Next question: - when *new regular user opens shared excel file* , will it _affect all other users by hiding/showing sheets_? - we don't wanna that scenario 😒
@@miiihaaas It should not do that. But if you are using a shared workbook where multiple users have the file open at the same time you will get strange results. If only one user at a time in the workbook then using 'If Then Else' code will ensure that all eventualities are covered.
@@Up4Excel Yes , file is shared and open by many users :( Tommorow I'll check how it works together with my college... I hope we'll find solution. Have nice day
Go to the developer ribbon and click the visual basic button. If you don't have the developer ribbon go to options to add it. If you're using a work computer macros could be disabled though.
Most likely you do not have macros enabled. Reopen the spreadsheet and ensure you enable macros. Failing that a reboot often works wonders on such errors 👍
Yes, you can set up an event procedure to run whenever the sheet is clicked on. This macro can then hide the contents in whatever way you choose. I have a video coming out soon on event procedures but to get an idea have a look at my video on how to auto start a macro when a spreadsheet opens. This will give you the idea 👍
@@azamfauzi_itd Yes, the video is here: ruclips.net/video/mWRVr5cCWNc/видео.html . You will need to google the code to use to hide the content but my guess it'll be something along the lines of selection.columns.visible = false but can't say for sure
You probably have workbook structure protection switched on. That prevents sheets being moved, hidden, unhidden etc. Click 'Protect Workbook' on the Review ribbon and see what happens. It will either unprotect it, ask for a password or ask if you want to protect it. If you have to remove a password you don't know than have a look this part of my other video here: ruclips.net/video/sSVX9xUow74/видео.html If you then want more detail on the method mentioned look at this video here ruclips.net/video/-iwGjJlOT_U/видео.html
I have noticed that when an Excel file is saved in SharePoint, and it is opened from within Teams, all Very Hidden tabs are displayed. Be careful with saving passwords I would say!
I'm offering personal coaching to only 2 people. Get details now ml.up4excel.com/htcapp04 - Offer Ends 19th August 2022
👉 Up4Excel Downloads Library: »» ml.up4excel.com/library
✅ FREE Access to ALL Up4Excel Files. Includes Excel Templates, Training Workbooks, Example Data, Cheat Sheets and more. New Content Added Weekly!
🎯 Prevent users accessing your hidden Excel sheets. Stop someone seeing it at all….they won't even know it exists! Hide anything you want on it like passwords, user data, usage data etc.
however, there are also tutorial videos on how to see very hidden sheets and the problem becomes simply a few more clicks, but in the end the "hidden sheet" is not so protected. How can you put a password for accessing only a sheet? Thank you
@@catalin.ardeleanu Have a look at this quick tip to password protect the code to unhide the very hidden sheets ruclips.net/video/hF47KOvpK68/видео.html . Of course someone very determined could then also crack that password with software but I guess you can't 100% protect any file really.
How can I unhide it
@@jhenalynmariano6125 Go in the VBA editor and change the properties to visible in the same way they changed to very hidden 👍
Thanks a lot for such a useful video
Glad you think so Javed 👍 John
Hi John.. thanks for the quickie tip. Thumbs up!!
No worries, thanks for watching 👍
this is a good & EASY method.
Glad to hear that, thanks for watching 👍 John
Thanks John. That was a GREAT Trick!!! very very useful !! : ) : )
Glad it was helpful, I certainly think it is 👍
big thanks
Glad it helped 👍 John
It was so simple. Loved it
I know, such a great little known feature
Is there anyway of preventing users from doing the same and changing it from "very hidden" to "visibile" if they know this trick? Like adding a password?
Yes, you could protect the VBA Project with a password so they can't access the property and therefore can't change it. See this video ruclips.net/video/hF47KOvpK68/видео.html 👍
Superb!
Glad you think so 👍 John
gyaan to badhiya diya par hume password wala tarika chahiye, jisse password dalte hi sheet open ho jaye. dhanyawaad
You could just link some code to a button that requests the password, and if they type in the correct one unhide the sheet. You can search this on the web as too much to go into here but essentially it needs a message box inside an if statement 👍
is it possible to hide certain tabs from different users in a sheet?
It is certainly possible but it's a lot of set-up. You either need people to log into your spreadsheet using a user form, or detect their windows username. Once you know whose in the spreadsheet you could hide or reveal sheets accordingly. Note you would need to ensure macros are enabled to make this all happen. See ruclips.net/video/XXbsJRWeLTY/видео.html for this bit
Thanks for your video. However, I notice that we could able to view those hidden sheets by uploading to Google sheet. How to prevent users to view those hidden sheet by this trick (uploading to Google Sheet)?
You could password protect the actual file so no-one can open it without the password, therefore forcing them to open it in Excel??
I am using excel file that is saved on OneDrive and shared with few people. Is there possibility to hide some sheets from specific people, and on same time same sheet should be visible for others?
Now you're asking! YES you can, but you will need to detect the user and then run code to hide or unhide sheets depending on what you detect. Too much to explain everything in writing, but using this code line "Set objNet = CreateObject("WScript.NetWork") " then this code "sUser = objNet.UserName" will set sUser to the windows logon name of whoever just opened the spreadsheet. Then use the techniques of method 3 in this video ruclips.net/video/XXbsJRWeLTY/видео.html to force macros on, and detect if the user is someone you want to hide or unhide sheets for. Good luck. Might make a video on it one day.
@@Up4Excel Thanks a lot for your replay!
Now, I'll try to figure it out what you wrote :)
Might subscribe to your channel one day :) when you make a video on this topoc
Have nice day
@@Up4Excel I figure out some parts (objNet, sUser)😁.
Scenario:
- *my windows log name is admin* and _it shows all sheets (for example: sheet1, sheet2, sheet3, ... sheet7)_
- *others windows log name is regular user* and _if shows just one/few sheet (for example: sheet3)_
- same excel file has been opened on few users and it is ready for collaboration
Next question:
- when *new regular user opens shared excel file* , will it _affect all other users by hiding/showing sheets_? - we don't wanna that scenario 😒
@@miiihaaas It should not do that. But if you are using a shared workbook where multiple users have the file open at the same time you will get strange results. If only one user at a time in the workbook then using 'If Then Else' code will ensure that all eventualities are covered.
@@Up4Excel Yes , file is shared and open by many users :(
Tommorow I'll check how it works together with my college... I hope we'll find solution.
Have nice day
Alt F11 isn’t working. How do I get into that view otherwise
Go to the developer ribbon and click the visual basic button. If you don't have the developer ribbon go to options to add it. If you're using a work computer macros could be disabled though.
how can I make the tab visible again? I've hidden it to share with people, but I want to be able to go back in and change things.
Just change the same properties back to visible instead of very hidden
Hi, I get an error message saying ”unablw to set the visible property of the worksheet class”. I have unprotrcted the sheet
Most likely you do not have macros enabled. Reopen the spreadsheet and ensure you enable macros. Failing that a reboot often works wonders on such errors 👍
Hi. Is there anyway to do this: I want my sheet is visible but when someone clicks on it, they cannot see the content?
Yes, you can set up an event procedure to run whenever the sheet is clicked on. This macro can then hide the contents in whatever way you choose. I have a video coming out soon on event procedures but to get an idea have a look at my video on how to auto start a macro when a spreadsheet opens. This will give you the idea 👍
@@Up4Excel thanks so much!
@@loveBeLun Hope it helped. The new video on event procedures is out this coming Monday (30th Nov 2020).
@@Up4Excel I am looking for this features too. Is the video published already? Thanks in advanced.
@@azamfauzi_itd Yes, the video is here: ruclips.net/video/mWRVr5cCWNc/видео.html . You will need to google the code to use to hide the content but my guess it'll be something along the lines of selection.columns.visible = false but can't say for sure
Hi, I was not able to use this function. Error message "Unable to set Visible property of the Worksheet class" - Any comments
Is the worksheet protected in any way? - i.e. sheet protection or workbook structure protection.
How do I unhide a sheet that is password protected? Do I right click and select "unprotect sheet"? I've tried that and it didn't work. Help pls.
You probably have workbook structure protection switched on. That prevents sheets being moved, hidden, unhidden etc. Click 'Protect Workbook' on the Review ribbon and see what happens. It will either unprotect it, ask for a password or ask if you want to protect it. If you have to remove a password you don't know than have a look this part of my other video here: ruclips.net/video/sSVX9xUow74/видео.html If you then want more detail on the method mentioned look at this video here ruclips.net/video/-iwGjJlOT_U/видео.html
I have noticed that when an Excel file is saved in SharePoint, and it is opened from within Teams, all Very Hidden tabs are displayed.
Be careful with saving passwords I would say!
I can't test this as I don't have SharePoint but that is a serious flaw. Thank you for sharing as something everyone should definitely be aware of 👍
I dissagree with "you can save passwords on a 'veryhidden' sheet".
Yes, fair enough as it is a risk if anyone knows how to unhide it.