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

2010-12-09 Thread Dave Bonallack
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

2010-12-09 Thread Rajesh K R
Hi Dave The code is working well, Thank u very much Regards Rajesh kainikkara On 12/9/10, Dave Bonallack wrote: > > Hi, > Try this. > > Sub Macro6() > If ActiveSheet.ProtectContents = True Then ActiveSheet.Unprotect Else > ActiveSheet.Protect > End Sub > > Regards - Dave. > >> Date: Wed, 8 De

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

2010-12-09 Thread Dave Bonallack
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 > From: rajeshkainikk...@g