Re: $$Excel-Macros$$ UNPROTECT EXCEL WORK BOOK

2013-09-20 Thread P.VIJAYKUMAR
hakar S H >> >> *Sent:* Friday, September 20, 2013 10:48 AM >> *To:* excel-...@googlegroups.com >> >> *Cc:* Soum >> *Subject:* Re: $$Excel-Macros$$ UNPROTECT EXCEL WORK BOOK >> >> >> >> i am not able to do it. will you please send me file af

Re: $$Excel-Macros$$ UNPROTECT EXCEL WORK BOOK

2013-09-20 Thread Prabhakar S H
.@googlegroups.com ] *On Behalf Of *Prabhakar S H > *Sent:* Friday, September 20, 2013 10:48 AM > *To:* excel-...@googlegroups.com > *Cc:* Soum > *Subject:* Re: $$Excel-Macros$$ UNPROTECT EXCEL WORK BOOK > > > > i am not able to do it. will you please send me file after re

Re: $$Excel-Macros$$ UNPROTECT EXCEL WORK BOOK

2013-09-19 Thread Prabhakar S H
Dear Vijay, I am not able to do it. plese send me file after releasing password. On Wednesday, September 18, 2013 12:21:19 PM UTC+5:30, vijay wrote: > Respected Prabhakar, > > Install and use the attached add-in to unprotect the workbook. > > > > > > Regards, > VIJAYKUMAR > > > On Wed, Sep 18,

Re: $$Excel-Macros$$ UNPROTECT EXCEL WORK BOOK

2013-09-19 Thread Prabhakar S H
i am not able to do it. will you please send me file after removing password from workbook. On Wednesday, September 18, 2013 12:01:06 PM UTC+5:30, ravinder negi wrote: > Try this code… > > > > > > Sub unprotecsheet() > > Dim wb As Workbook > > Dim sh As Worksheet > > Set wb = ThisWorkbook >

RE: $$Excel-Macros$$ UNPROTECT EXCEL WORK BOOK

2013-09-17 Thread Ravinder
Try this code. Sub unprotecsheet() Dim wb As Workbook Dim sh As Worksheet Set wb = ThisWorkbook For Each sh In wb.Sheets sh.Unprotect "AAABAABABBAR" Next End Sub From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Prabhakar S H Sent: