how to open a sheet with password
Dear All
is it possible to lock a Sheet with password.
like in my workbook there have 3 sheets, i want to lock sheet 1 & 3 with password. when anyone want to see the sheet, click on the sheet 1/sheet 3 then it will ask password 1st, after inputting the correct password then it will allow to enter into that sheet.
TIA
Review ribbon | Protect Sheet.
https://www.officetooltips.com/excel...t_options.html
Last edited by AliGW; 01-27-2022 at 05:54 AM.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
AliGW thanks for your reply,
im not getting any option to protect myself from entering into the sheet from "Review ribbon | Protect Sheet."
this option block me to edit. can you please guide me more.
Look at the link I gave you.
Also see here: https://www.dummies.com/article/tech...el-2010-191900
You will need to lock cells that you want to protect and unlock those that can remain editable. If you want the sheet to be read only, then lock the lot (I believe that should be the default, anyway).
Please work through the tutorials I've linked to - all the information is there.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks