Re: $$Excel-Macros$$ UNPROTECT EXCEL WORK BOOK
Respected Prabhakar, Install the addin a new excel work book.To install the addin go to the excel options button and go to the add-in tab,in the rightside down part you will have a go button .Click it and you will have a dialog box with brose and three other buttons.Click brose and select the saved add-in file.It should appear on the list beside and also should be checked.then the add-in will be installed.After installing you will a new menu item called straxx add-in which contains unprotect sheet and unprotect workbook tabs.Close the work book and open any password protected workbook.Go to the straxx menu and use the uprotect sheet and unprotect workbook tabs to unprotect the sheet or workbook respectively. Regards, Vijaykumar On Fri, Sep 20, 2013 at 2:02 PM, Prabhakar S H wrote: > Thanks Ravinder, > > can you tell me how did you done this and also tell me how to lock the > work book as it is. > > Rgds, > Prabhakar > > On Friday, September 20, 2013 10:50:54 AM UTC+5:30, ravinder negi wrote: > >> PFA >> >> >> >> *From:* excel-...@googlegroups.com [mailto:excel-...@**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 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 >> >> >> >> For Each sh In wb.Sheets >> >> sh.Unprotect "AAABAABABBAR" >> >> >> >> Next >> >> >> >> >> >> End Sub >> >> >> >> *From:* excel-...@googlegroups.com [mailto:excel-...@**googlegroups.com] >> *On Behalf Of *Prabhakar S H >> *Sent:* Wednesday, September 18, 2013 11:46 AM >> *To:* excel-...@googlegroups.com >> *Subject:* $$Excel-Macros$$ UNPROTECT EXCEL WORK BOOK >> >> >> >> Dear Team, >> >> >> >> Pls help me to unprotect entire excel work book. Also tell me the >> procedure i want to learn. >> >> >> >> Rgds, >> >> Prabhakar >> >> -- >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >> https://www.facebook.com/**discussexcel<https://www.facebook.com/discussexcel> >> >> FORUM RULES >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> 2) Don't post a question in the thread of another member. >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> 4) Acknowledge the responses you receive, good or bad. >> 5) Jobs posting is not allowed. >> 6) Sharing copyrighted material and their links is not allowed. >> >> NOTE : Don't ever post confidential data in a workbook. Forum owners and >> members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google Groups >> "MS EXCEL AND VBA MACROS" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to excel-macros...@googlegroups.**com. >> To post to this group, send email to excel-...@googlegroups.com. >> Visit this group at >> http://groups.google.com/**group/excel-macros<http://groups.google.com/group/excel-macros> >> . >> For more options, visit >> https://groups.google.com/**groups/opt_out<https://groups.google.com/groups/opt_out> >> . >> >> -- >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >> https://www.facebook.com/**discussexcel<https://www.facebook.com/discussexcel> >> >> FORUM RULES >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> 2) Don't post a question in the thread of another member. >> 3) Don't post questions
Re: $$Excel-Macros$$ UNPROTECT EXCEL WORK BOOK
Thanks Ravinder, can you tell me how did you done this and also tell me how to lock the work book as it is. Rgds, Prabhakar On Friday, September 20, 2013 10:50:54 AM UTC+5:30, ravinder negi wrote: > PFA > > > > *From:* excel-...@googlegroups.com [mailto: > excel-...@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 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 > > > > For Each sh In wb.Sheets > > sh.Unprotect "AAABAABABBAR" > > > > Next > > > > > > End Sub > > > > *From:* excel-...@googlegroups.com [mailto:excel-...@googlegroups.com] *On > Behalf Of *Prabhakar S H > *Sent:* Wednesday, September 18, 2013 11:46 AM > *To:* excel-...@googlegroups.com > *Subject:* $$Excel-Macros$$ UNPROTECT EXCEL WORK BOOK > > > > Dear Team, > > > > Pls help me to unprotect entire excel work book. Also tell me the > procedure i want to learn. > > > > Rgds, > > Prabhakar > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros...@googlegroups.com. > To post to this group, send email to excel-...@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/groups/opt_out. > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros...@googlegroups.com . > To post to this group, send email to excel-...@googlegroups.com > . > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/groups/opt_out. > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing cop
Re: $$Excel-Macros$$ UNPROTECT EXCEL WORK BOOK
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, 2013 at 12:01 PM, Ravinder > > > wrote: > >> 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-...@googlegroups.com [mailto: >> excel-...@googlegroups.com ] *On Behalf Of *Prabhakar S H >> *Sent:* Wednesday, September 18, 2013 11:46 AM >> *To:* excel-...@googlegroups.com >> *Subject:* $$Excel-Macros$$ UNPROTECT EXCEL WORK BOOK >> >> ** ** >> >> Dear Team, >> >> >> >> Pls help me to unprotect entire excel work book. Also tell me the >> procedure i want to learn. >> >> >> >> Rgds, >> >> Prabhakar >> >> -- >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> 2) Don't post a question in the thread of another member. >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> 4) Acknowledge the responses you receive, good or bad. >> 5) Jobs posting is not allowed. >> 6) Sharing copyrighted material and their links is not allowed. >> >> NOTE : Don't ever post confidential data in a workbook. Forum owners and >> members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google Groups >> "MS EXCEL AND VBA MACROS" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to excel-macros...@googlegroups.com . >> To post to this group, send email to excel-...@googlegroups.com >> . >> Visit this group at http://groups.google.com/group/excel-macros. >> For more options, visit https://groups.google.com/groups/opt_out. >> >> -- >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> 2) Don't post a question in the thread of another member. >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> 4) Acknowledge the responses you receive, good or bad. >> 5) Jobs posting is not allowed. >> 6) Sharing copyrighted material and their links is not allowed. >> >> NOTE : Don't ever post confidential data in a workbook. Forum owners and >> members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google Groups >> "MS EXCEL AND VBA MACROS" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to excel-macros...@googlegroups.com . >> To post to this group, send email to excel-...@googlegroups.com >> . >> Visit this group at http://groups.google.com/group/excel-macros. >> For more options, visit https://groups.google.com/groups/opt_out. >> > > > > -- > > > > > > > > > > P.VIJAY KUMAR > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/e
Re: $$Excel-Macros$$ UNPROTECT EXCEL WORK BOOK
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 > > > > For Each sh In wb.Sheets > > sh.Unprotect "AAABAABABBAR" > > > > Next > > > > > > End Sub > > > > *From:* excel-...@googlegroups.com [mailto: > excel-...@googlegroups.com ] *On Behalf Of *Prabhakar S H > *Sent:* Wednesday, September 18, 2013 11:46 AM > *To:* excel-...@googlegroups.com > *Subject:* $$Excel-Macros$$ UNPROTECT EXCEL WORK BOOK > > > > Dear Team, > > > > Pls help me to unprotect entire excel work book. Also tell me the > procedure i want to learn. > > > > Rgds, > > Prabhakar > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros...@googlegroups.com . > To post to this group, send email to excel-...@googlegroups.com > . > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/groups/opt_out. > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
RE: $$Excel-Macros$$ UNPROTECT EXCEL WORK BOOK
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: Wednesday, September 18, 2013 11:46 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ UNPROTECT EXCEL WORK BOOK Dear Team, Pls help me to unprotect entire excel work book. Also tell me the procedure i want to learn. Rgds, Prabhakar -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.