After I hide the sheet with password (lock project for viewing) and save as Macro Enabled workbook, and it functions okay when I need to let the sheet visible.
However, when I save the excel as a Excel Workbook, it will be no need to type the password when I want it to be visible.
How can I solved the problems? Thanks
Please Elaborate
Please consider adding a * if I helped
Please ignore this post,.................
Last edited by forward; 05-31-2016 at 12:12 PM. Reason: wrong reply
Thanks for reply.
I want to hide a sheet(SheetVeryHidden) with a password in the workbook.
Users can see the unhide sheets. However, if they want to see the sheet(SheetVeryHidden), they need to input password.How could I do that?
Hello forward,
Welcome to the Forum.
Attached is a very basic sample Workbook, of how it could be done.
The Password is "test", without the quotes.
Right Click on the Sheet Tab of Sheet 1, to view the Code and methods applied. Hopefully you would be able to build and amend it to your liking.
Regards.
Last edited by Winon; 06-01-2016 at 10:18 AM. Reason: Included password.
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
Thanks for help, Winon.Originally Posted by Winon
Hello forward,
Welcome to the Forum.
Attached is a very basic sample Workbook, of how it could be done.
The Password is "test", without the quotes.
Right Click on the Sheet Tab of Sheet 1, to view the Code and methods applied. Hopefully you would be able to build and amend it to your liking.
Regards.
How can I create a btn "password" that link to access control? Any code needed to be input?
Hi forward,
Do you mean that you don't want the Black Oval with the Word "Password", but a Button instead? Have you clicked on the Black Oval, which acts the same as an actual Button?
Regards.
Okay, see that. Thank you for help.Hi forward,
Do you mean that you don't want the Black Oval with the Word "Password", but a Button instead? Have you clicked on the Black Oval, which acts the same as an actual Button?
Regards.
Hello forward,
You are welcome, glad I could help.
Please don't quote whole posts -- it's just clutter.
If you are responding to a post out of sequence, limit quoted content to a few relevant lines that makes clear to whom and what you are responding
For normal conversational replies, just use the QUICK REPLY box below.
Regards.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks