Dear Sir
I have used this code in one of my project viz.
Private Sub Worksheet_Activate()
Sheet2.Protect "1823"
Dim pass As String
pass = InputBox("N Shivkumar has for obvious reasons set a Password, kindly
enter password to unprotect sheet")
If pass = "1823" Then
Sheet2.Unprotect "1823"
El
Hello Dear,
Following is the Code to Protect Unprotect Excel Sheet Using VBA.
''
Sub ProtectSheet()
Dim Passwo
Hi,
The code for protecting a worsheet is:
Sheets("YourSheetName").Protect Password = "YourPassword"
Regards - Dave.
Date: Fri, 26 Mar 2010 17:40:58 +0530
Subject: $$Excel-Macros$$ how can protect the excel sheet in VBA Passward.
From: jaihumtu...@gmail.com
To: excel-macros@googlegrou
