Re: $$Excel-Macros$$ Password protect hidden sheets
Hi priyanka, Try through below vba Code... Private Sub Worksheet_Activate() Sheet1.Protect 1823 Sheets(1).Visible = xlSheetVeryHidden Dim pass As String pass = InputBox(kindly enter password to unprotect sheet) If pass = 1823 Then Sheet1.Unprotect 1823 Sheets(1).Visible = True Else MsgBox Incorrect Password Worksheets(2).Activate End If End Sub On Tue, Jan 31, 2012 at 12:05 PM, PrIyAnKa p.dhamsa...@gmail.com wrote: Dear Team Kindly let me know if i have a workbook having 3 sheets in it, and i hide 2 sheets of it and when next time i unhide those sheets a password box gets open and without password it can't be unhide I have excel 2007 version If any more details req kindly let me know Regards Priyanka -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
RE: $$Excel-Macros$$ Password protect hidden sheets
Hi After hiding worksheet.. paste this in worksheet code module Private Sub Worksheet_Activate() Dim StrPass As String With Me .Protect YourPassWord .Visible = xlSheetHidden StrPass = InputBox(kindly enter password to unprotect sheet) If StrPass = YourPassWord Then .Unprotect YourPassWord .Visible = True Else MsgBox Incorrect Password,Woksheet can not be visible, vbCritical, Password Required End If End With End Sub From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: Jan/Tue/2012 01:49 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Password protect hidden sheets Hi priyanka, Try through below vba Code... Private Sub Worksheet_Activate() Sheet1.Protect 1823 Sheets(1).Visible = xlSheetVeryHidden Dim pass As String pass = InputBox(kindly enter password to unprotect sheet) If pass = 1823 Then Sheet1.Unprotect 1823 Sheets(1).Visible = True Else MsgBox Incorrect Password Worksheets(2).Activate End If End Sub On Tue, Jan 31, 2012 at 12:05 PM, PrIyAnKa p.dhamsa...@gmail.com wrote: Dear Team Kindly let me know if i have a workbook having 3 sheets in it, and i hide 2 sheets of it and when next time i unhide those sheets a password box gets open and without password it can't be unhide I have excel 2007 version If any more details req kindly let me know Regards Priyanka -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari http://excelmacroworld.blogspot.com/ http://excelmacroworld.blogspot.com/ http://noorain-ansari.blogspot.com/ http://noorain-ansari.blogspot.com/ -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Password protect hidden sheets
dear priyanka better you can hide data range and protect your sheet. instead of hiding whole sheet. or as sam said you can protect the workbook structure. @rajan other folks if the macros or disabled? if the codes are modified or deleted? On Tue, Jan 31, 2012 at 6:55 PM, Rajan_Verma rajanverma1...@gmail.comwrote: *Hi * * * *After hiding* worksheet.. paste this in worksheet code module ** ** Private Sub Worksheet_Activate() Dim StrPass As String With Me .Protect YourPassWord .Visible = *xlSheetHidden* StrPass = InputBox(kindly enter password to unprotect sheet)*** * If StrPass = YourPassWord Then .Unprotect YourPassWord .Visible = True Else MsgBox Incorrect Password,Woksheet can not be visible, vbCritical, Password Required End If End With End Sub ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *NOORAIN ANSARI *Sent:* Jan/Tue/2012 01:49 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Password protect hidden sheets ** ** Hi priyanka, Try through below vba Code... Private Sub Worksheet_Activate() Sheet1.Protect 1823 Sheets(1).Visible = xlSheetVeryHidden Dim pass As String pass = InputBox(kindly enter password to unprotect sheet) If pass = 1823 Then Sheet1.Unprotect 1823 Sheets(1).Visible = True Else MsgBox Incorrect Password Worksheets(2).Activate End If End Sub On Tue, Jan 31, 2012 at 12:05 PM, PrIyAnKa p.dhamsa...@gmail.com wrote:* *** Dear Team ** ** Kindly let me know if i have a workbook having 3 sheets in it, and i hide 2 sheets of it and when next time i unhide those sheets a password box gets open and without password it can't be unhide ** ** I have excel 2007 version ** ** If any more details req kindly let me know ** ** Regards Priyanka -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ ** ** -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- *Great day,* *viper* -- FORUM RULES (986+ members already BANNED
Re: $$Excel-Macros$$ Password protect hidden sheets
Dear Sam After protecting the sheet i cant hide it, and i want to hide it so other person can not see it, And password is req while unhidding the sheet is because if by mistake someone see the sheet and tries to unhide it , he cant do it w/o password SO is there anything like this ,except macro.. Noorain,Rajan and Sam . On Wed, Feb 1, 2012 at 12:38 PM, The Viper viper@gmail.com wrote: dear priyanka better you can hide data range and protect your sheet. instead of hiding whole sheet. or as sam said you can protect the workbook structure. @rajan other folks if the macros or disabled? if the codes are modified or deleted? On Tue, Jan 31, 2012 at 6:55 PM, Rajan_Verma rajanverma1...@gmail.comwrote: *Hi * * * *After hiding* worksheet.. paste this in worksheet code module ** ** Private Sub Worksheet_Activate() Dim StrPass As String With Me .Protect YourPassWord .Visible = *xlSheetHidden* StrPass = InputBox(kindly enter password to unprotect sheet)** ** If StrPass = YourPassWord Then .Unprotect YourPassWord .Visible = True Else MsgBox Incorrect Password,Woksheet can not be visible, vbCritical, Password Required End If End With End Sub ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *NOORAIN ANSARI *Sent:* Jan/Tue/2012 01:49 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Password protect hidden sheets ** ** Hi priyanka, Try through below vba Code... Private Sub Worksheet_Activate() Sheet1.Protect 1823 Sheets(1).Visible = xlSheetVeryHidden Dim pass As String pass = InputBox(kindly enter password to unprotect sheet) If pass = 1823 Then Sheet1.Unprotect 1823 Sheets(1).Visible = True Else MsgBox Incorrect Password Worksheets(2).Activate End If End Sub On Tue, Jan 31, 2012 at 12:05 PM, PrIyAnKa p.dhamsa...@gmail.com wrote: Dear Team ** ** Kindly let me know if i have a workbook having 3 sheets in it, and i hide 2 sheets of it and when next time i unhide those sheets a password box gets open and without password it can't be unhide ** ** I have excel 2007 version ** ** If any more details req kindly let me know ** ** Regards Priyanka -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ ** ** -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive
RE: $$Excel-Macros$$ Password protect hidden sheets
You can Protect Workbook. After hiding Worksheets.. Rajan From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of PrIyAnKa Sent: Jan/Tue/2012 12:05 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Password protect hidden sheets Dear Team Kindly let me know if i have a workbook having 3 sheets in it, and i hide 2 sheets of it and when next time i unhide those sheets a password box gets open and without password it can't be unhide I have excel 2007 version If any more details req kindly let me know Regards Priyanka -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Password protect hidden sheets
Hi Priyanka, I think you can't unhide sheet without password.. refer to below link.. http://www.howtogeek.com/howto/14160/hide-and-unhide-worksheets-and-workbooks-in-excel-2007-2010/ On Tue, Jan 31, 2012 at 12:05 PM, PrIyAnKa p.dhamsa...@gmail.com wrote: Dear Team Kindly let me know if i have a workbook having 3 sheets in it, and i hide 2 sheets of it and when next time i unhide those sheets a password box gets open and without password it can't be unhide I have excel 2007 version If any more details req kindly let me know Regards Priyanka -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Password protect hidden sheets
First assign a password to the sheet before hiding it, so that when other user unhide's it, the sheet will be in read only mode and if the user want to do changes it will prompt for password. You can do this by using keyboard shortcut: ALT+T,P,P and set the password. Hope it will help u. On Tue, Jan 31, 2012 at 12:58 PM, PrIyAnKa p.dhamsa...@gmail.com wrote: I want that other person can open the whole sheet but he can't open the hidden sheets w/o password Can it be done? protecting a whole workbook is not useful for me , Rajan On Tue, Jan 31, 2012 at 12:31 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Hi Priyanka, I think you can't unhide sheet without password.. refer to below link.. http://www.howtogeek.com/howto/14160/hide-and-unhide-worksheets-and-workbooks-in-excel-2007-2010/ On Tue, Jan 31, 2012 at 12:05 PM, PrIyAnKa p.dhamsa...@gmail.com wrote: Dear Team Kindly let me know if i have a workbook having 3 sheets in it, and i hide 2 sheets of it and when next time i unhide those sheets a password box gets open and without password it can't be unhide I have excel 2007 version If any more details req kindly let me know Regards Priyanka -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com