RE: $$Excel-Macros$$ how to protect & unprotect the sheet with same button

Hi Rajesh, You're welcome. Regards - Dave. > Date: Thu, 9 Dec 2010 20:23:05 +0530 > Subject: Re: $$Excel-Macros$$ how to protect & unprotect the sheet with same > button > From: rajeshkainikk...@gmail.com > To: excel-macros@googlegroups.com > > Hi Dave > &g

Re: $$Excel-Macros$$ how to protect & unprotect the sheet with same button

ards - Dave. > >> Date: Wed, 8 Dec 2010 20:49:58 +0530 >> Subject: $$Excel-Macros$$ how to protect & unprotect the sheet with same >> button >> From: rajeshkainikk...@gmail.com >> To: excel-macros@googlegroups.com >> >> Hi Experts >> >> i

RE: $$Excel-Macros$$ how to protect & unprotect the sheet with same button

Hi, Try this. Sub Macro6() If ActiveSheet.ProtectContents = True Then ActiveSheet.Unprotect Else ActiveSheet.Protect End Sub Regards - Dave. > Date: Wed, 8 Dec 2010 20:49:58 +0530 > Subject: $$Excel-Macros$$ how to protect & unprotect the sheet with same > button > Fro

$$Excel-Macros$$ how to protect & unprotect the sheet with same button

Hi Experts i am want to give an edit button in my worksheet, for protecting & unprotecting the sheet how can i use it. I try this code but not working,pls correct it Sub Macro6() If ActiveSheet.Protect = True Then ActiveSheet.Unprotect Else If ActiveSheet.Protect = False Then ActiveSheet.Protect