Dear Lucky Ji.,
Thanks for your valuable help. I am having a requirement of protecting the
entire sheet.
The query is - How should i lock a particular book with a pass word. When
ever a user tries to open that work book it has to be asked password. Then
only the sheet should open and the contents
Hi Team,
Attached below is the Marco code for Protecting cells in excel sheet.
Steps to Protect a cell
Step 1 - Open that particular file which you want to lock and hide any
formulas in sheet.
Step 2 - Open file "PROTECT" and press CTRL + j
Steps to Unprotect a cell
Step 1 - Open that particul
Hi Team,
Attached below is the Marco code for Protecting cells in excel sheet.
Steps to Protect a cell
Step 1 - Open that particular file which you want to lock and hide any
formulas in sheet.
Step 2 - Open file "PROTECT" and press CTRL + j
Steps to Unprotect a cell
Step 1 - Open that particul
