Hi Preeti,
Can we do Unprotect All also?
But system should ask the password as usual for protect unprotect.
Regards
Pravin.
On Tue, Apr 23, 2013 at 9:29 PM, priti verma pritiverma1...@gmail.comwrote:
Hi Kuldeep,
Please use the following code
Sub ProtectAll()
Dim sheet As Worksheet
Dim
Hi Pravin,
i have just add inputbox for value input and replace sheet.protect
with sheet.unprotect for Unprotect all sheets
for protect all sheets
Sub ProtectAll()
Dim sheet As Worksheet
Dim myPassword As String
myPassword = InputBox(Enter password)
For Each sheet In ActiveWorkbook.Worksheets
*Thanks will try for the same*
*
*
*Regards,*
*Pravin Gunjal.*
-- Forwarded message --
From: xlstime xlst...@gmail.com
Date: Fri, Apr 26, 2013 at 7:26 PM
Subject: Re: $$Excel-Macros$$ Protect All Sheets Via VBA
To: excel-macros@googlegroups.com
Hi Pravin,
i have just add
Hi Pravin,
Yes you can do it.Please find the aatchment.
Regards
Priti verma
On Fri, Apr 26, 2013 at 7:15 PM, Pravin Gunjal isk1...@gmail.com wrote:
Hi Preeti,
Can we do Unprotect All also?
But system should ask the password as usual for protect unprotect.
Regards
Pravin.
On Tue,
Hi Experts,
I want to protect all sheets Via VBA. Anyone please help me.
Regards,
Kuldeep Singh
Info Edge India Limited (naukri.com)
Phone.: +91-0120-4841100, Extn.: 2467, 9716615535
naukrikuld...@gmail.com || www.naukri.com
*Please* *Consider the environment. Please don't print this e-mail
Sent: Tue, April 23, 2013 11:46:54 AM
Subject: $$Excel-Macros$$ Protect All Sheets Via VBA
Hi Experts,
I want to protect all sheets Via VBA. Anyone please help me.
Regards,
Kuldeep Singh
Info Edge India Limited (naukri.com)
Phone.: +91-0120-4841100, Extn.: 2467, 9716615535
naukrikuld
Hi Kuldeep,
Please use the following code
Sub ProtectAll()
Dim sheet As Worksheet
Dim myPassword As String
myPassword = password
For Each sheet In ActiveWorkbook.Worksheets
sheet.Protect Password:=myPassword
Next
End Sub
Regards,
Priti verma
On Tue, Apr 23, 2013 at 9:16 PM, Kuldeep Singh
Thanks Paul Preeti.
Regards,
Kuldeep Singh
Info Edge India Limited (naukri.com)
Phone.: +91-0120-4841100, Extn.: 2467, 9716615535
naukrikuld...@gmail.com || www.naukri.com
*Please* *Consider the environment. Please don't print this e-mail unless
you really need to.*
*
*
On Tue, Apr 23, 2013 at