Re: $$Excel-Macros$$ Enable & Disable Ctrl+D with passward
Dear, I think using Ctrl + Z will allow you to take back the action you performed i.e Undo the last action ;-). This should help. If not, check other experts advice. Thanks, On Wed, Jun 27, 2012 at 12:33 PM, Muralidhar E wrote: > > Dear all, > > Iam using Office 2007, when iam need to use Crl+F accidently iam hitting > Ctrl+D, iam loosing some data and iam unable to find the changes happening > to the data file. > Iam want to disable Ctrl+D option with a passward and the same enable with > passward, it should for that worksheet only. > > Thanks in advance. > -- > *Thanks & Regards,* > ** > *Muralidhar E.* > > -- > -- > 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 > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > > > -- Ahmed Bawazir *احمد باوزير* -- -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Enable & Disable Ctrl+D with passward
Hi, But it will not come to the notice at the same time, it was accidently going on, iam not observing it later it was effecting to the data. On Wed, Jun 27, 2012 at 3:09 PM, Ahmed Honest wrote: > Dear, > > I think using Ctrl + Z will allow you to take back the action you > performed i.e Undo the last action ;-). This should help. If not, check > other experts advice. > > Thanks, > > > > > On Wed, Jun 27, 2012 at 12:33 PM, Muralidhar E wrote: > >> >> Dear all, >> >> Iam using Office 2007, when iam need to use Crl+F accidently iam hitting >> Ctrl+D, iam loosing some data and iam unable to find the changes happening >> to the data file. >> Iam want to disable Ctrl+D option with a passward and the same enable >> with passward, it should for that worksheet only. >> >> Thanks in advance. >> -- >> *Thanks & Regards,* >> ** >> *Muralidhar E.* >> >> -- >> -- >> 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 >> >> To unsubscribe, send a blank email to >> excel-macros+unsubscr...@googlegroups.com >> >> >> > > > > -- > Ahmed Bawazir > *احمد باوزير* > > -- *Thanks & Regards,* ** *Muralidhar E.* -- -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Enable & Disable Ctrl+D with passward
Dear Murali, Please try it.. Private Sub Workbook_Open() Application.OnKey "^d", "" End Sub Private Sub Workbook_BeforeClose(Cancel As Boolean) Application.OnKey "^d" End Sub -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Wed, Jun 27, 2012 at 3:03 PM, Muralidhar E wrote: > > Dear all, > > Iam using Office 2007, when iam need to use Crl+F accidently iam hitting > Ctrl+D, iam loosing some data and iam unable to find the changes happening > to the data file. > Iam want to disable Ctrl+D option with a passward and the same enable with > passward, it should for that worksheet only. > > Thanks in advance. > -- > Thanks & Regards, > > Muralidhar E. > > -- > -- > 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 > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Enable & Disable Ctrl+D with passward
Dear Murali, See attached sheet for reference. On Wed, Jun 27, 2012 at 3:56 PM, NOORAIN ANSARI wrote: > Dear Murali, > > Please try it.. > > Private Sub Workbook_Open() > Application.OnKey "^d", "" > End Sub > > Private Sub Workbook_BeforeClose(Cancel As Boolean) > Application.OnKey "^d" > End Sub > > -- > Thanks & regards, > Noorain Ansari > www.noorainansari.com > www.excelmacroworld.blogspot.com > > On Wed, Jun 27, 2012 at 3:03 PM, Muralidhar E wrote: >> >> Dear all, >> >> Iam using Office 2007, when iam need to use Crl+F accidently iam hitting >> Ctrl+D, iam loosing some data and iam unable to find the changes happening >> to the data file. >> Iam want to disable Ctrl+D option with a passward and the same enable with >> passward, it should for that worksheet only. >> >> Thanks in advance. >> -- >> Thanks & Regards, >> >> Muralidhar E. >> >> -- >> -- >> 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 >> >> To unsubscribe, send a blank email to >> excel-macros+unsubscr...@googlegroups.com >> >> -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com Murali(Please Check).xlsm Description: Binary data
Re: $$Excel-Macros$$ Enable & Disable Ctrl+D with passward
The suggested method is changing the ctrl-D keystroke for the Excel Application. Not just the single workbook. To do it for a single workbook, but not other open workbooks, you would need to put the commands in Workbook_Activate/deactivate events. As for password protecting it... There are several ways, some more secure than others. However, if you put the enable/disable commands in the Activate/Deactivate events, the user will have to enter the password whenever he/she switches from one workbook to another! although, it MIGHT be possible to store the user entered password in a Public variable and test it during the event macro. As for how to prompt for the password: How "critical" is this password protection? For instance: if it is just a "formality", and you don't care if the password is displayed while typing, you could use an input box, have the user enter the password, then compare the returned value to your stored password. If you want the password to appear as: then that takes a bit more work. also, where is the "correct" value stored? within the VBA code? on a hidden worksheet? in a file on the network? If you don't want the users to be able to read the password in the VBA code, you'll have to password protect the VBA project also... let me know how you would like this to work... Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: Muralidhar E To: excel-macros@googlegroups.com Sent: Wed, June 27, 2012 7:02:54 AM Subject: Re: $$Excel-Macros$$ Enable & Disable Ctrl+D with passward Dear all, At the same opened other excel files also not working the Ctrl+D option. I want to disable this option for the same sheet with a passward for enabling and disbling.It will works for other files as usually. Thanks in advance. On Wed, Jun 27, 2012 at 4:24 PM, Muralidhar E wrote: Hi, > >Thank u, > >But i am also need the passward to enbale and disable Ctrl+D option. >Thanks in advance. > > >Thanks & Regards, > >Muralidhar E. >Think different >Do Different >Make different > > >On Wed, Jun 27, 2012 at 3:58 PM, NOORAIN ANSARI >wrote: > >Dear Murali, >> >>See attached sheet for reference. >> >> >>On Wed, Jun 27, 2012 at 3:56 PM, NOORAIN ANSARI >> wrote: >>> Dear Murali, >>> >>> Please try it.. >>> >>> Private Sub Workbook_Open() >>> Application.OnKey "^d", "" >>> End Sub >>> >>> Private Sub Workbook_BeforeClose(Cancel As Boolean) >>> Application.OnKey "^d" >>> End Sub >>> >>> -- >>> Thanks & regards, >>> Noorain Ansari >>> www.noorainansari.com >>> www.excelmacroworld.blogspot.com >>> >>> On Wed, Jun 27, 2012 at 3:03 PM, Muralidhar E >wrote: >>>> >>>> Dear all, >>>> >>>> Iam using Office 2007, when iam need to use Crl+F accidently iam hitting >>>> Ctrl+D, iam loosing some data and iam unable to find the changes happening >>>> to the data file. >>>> Iam want to disable Ctrl+D option with a passward and the same enable with >>>> passward, it should for that worksheet only. >>>> >>>> Thanks in advance. >>>> -- >>>> Thanks & Regards, >>>> >>>> Muralidhar E. >>>> >>>> -- >>>> -- >>>> 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. >>>> >>>>-
RE: $$Excel-Macros$$ Enable & Disable Ctrl+D with passward
Do you have any add-in or macro in personal.xlsb which have any macro assigned Ctrl+D?? Because excel default Ctrl+D just fill down the data. Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Muralidhar E Sent: 27 June 2012 3:18 To: excel-macros@googlegroups.com Cc: ahmedhon...@gmail.com Subject: Re: $$Excel-Macros$$ Enable & Disable Ctrl+D with passward Hi, But it will not come to the notice at the same time, it was accidently going on, iam not observing it later it was effecting to the data. On Wed, Jun 27, 2012 at 3:09 PM, Ahmed Honest wrote: Dear, I think using Ctrl + Z will allow you to take back the action you performed i.e Undo the last action ;-). This should help. If not, check other experts advice. Thanks, On Wed, Jun 27, 2012 at 12:33 PM, Muralidhar E wrote: Dear all, Iam using Office 2007, when iam need to use Crl+F accidently iam hitting Ctrl+D, iam loosing some data and iam unable to find the changes happening to the data file. Iam want to disable Ctrl+D option with a passward and the same enable with passward, it should for that worksheet only. Thanks in advance. -- Thanks & Regards, Muralidhar E. -- -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com <mailto:excel-macros%2bunsubscr...@googlegroups.com> -- Ahmed Bawazir احمد باوزير -- Thanks & Regards, Muralidhar E. -- -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Enable & Disable Ctrl+D with passward
Hi group, Because of CTRl+D just fill down the data iam facing this problem, when i want to use Ctrl+F unfortunatley it was accidently clicking Ctrl+D iam not observing it later it was effecting to the data. So i what i need is i want to *disable Ctrl+D with a passward* and same time i want to *enable with a passward*. I think it will usefull for others also. Thanks in Advance. On Wed, Jun 27, 2012 at 6:38 PM, Rajan_Verma wrote: > Do you have any add-in or macro in personal.xlsb which have any macro > assigned Ctrl+D?? > > Because excel default Ctrl+D just fill down the data. > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Muralidhar E > *Sent:* 27 June 2012 3:18 > *To:* excel-macros@googlegroups.com > *Cc:* ahmedhon...@gmail.com > > *Subject:* Re: $$Excel-Macros$$ Enable & Disable Ctrl+D with passward > > ** ** > > > Hi, > > > > But it will not come to the notice at the same time, it was accidently > going on, iam not observing it later it was effecting to the data. > > > > > On Wed, Jun 27, 2012 at 3:09 PM, Ahmed Honest > wrote: > > Dear, > > > > I think using Ctrl + Z will allow you to take back the action you > performed i.e Undo the last action ;-). This should help. If not, check > other experts advice. > > > > Thanks, > > > > > > > > On Wed, Jun 27, 2012 at 12:33 PM, Muralidhar E > wrote: > > > Dear all, > > > > Iam using Office 2007, when iam need to use Crl+F accidently iam hitting > Ctrl+D, iam loosing some data and iam unable to find the changes happening > to the data file. > > Iam want to disable Ctrl+D option with a passward and the same enable with > passward, it should for that worksheet only. > > > > Thanks in advance. > -- > > *Thanks & Regards,* > > > > *Muralidhar E.* > > ** ** > > -- > -- > 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 > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > > > > > > > > -- > > Ahmed Bawazir > > *احمد باوزير* > > ** ** > > > > > -- > > *Thanks & Regards,* > > > > *Muralidhar E.* > > ** ** > > -- > -- > 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 > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@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 answer
Re: $$Excel-Macros$$ Enable & Disable Ctrl+D with passward
Hi gm experts, is anybody solve my problem reg. disable ctrl+d option. Iam waiting for solution for the problem. On Thu, Jun 28, 2012 at 2:34 PM, Muralidhar E wrote: > Hi group, > > Because of CTRl+D just fill down the data iam facing this problem, when i > want to use Ctrl+F unfortunatley it was accidently clicking Ctrl+D iam not > observing it later it was effecting to the data. > So i what i need is i want to *disable Ctrl+D with a passward* and > same time i want to *enable with a passward*. > > I think it will usefull for others also. > > Thanks in Advance. > > > > On Wed, Jun 27, 2012 at 6:38 PM, Rajan_Verma wrote: > >> Do you have any add-in or macro in personal.xlsb which have any macro >> assigned Ctrl+D?? >> >> Because excel default Ctrl+D just fill down the data. >> >> * * >> >> *Regards* >> >> *Rajan verma* >> >> *+91 7838100659 [IM-Gtalk]* >> >> ** ** >> >> *From:* excel-macros@googlegroups.com [mailto: >> excel-macros@googlegroups.com] *On Behalf Of *Muralidhar E >> *Sent:* 27 June 2012 3:18 >> *To:* excel-macros@googlegroups.com >> *Cc:* ahmedhon...@gmail.com >> >> *Subject:* Re: $$Excel-Macros$$ Enable & Disable Ctrl+D with passward >> >> ** ** >> >> >> Hi, >> >> >> >> But it will not come to the notice at the same time, it was accidently >> going on, iam not observing it later it was effecting to the data. >> >> >> >> >> On Wed, Jun 27, 2012 at 3:09 PM, Ahmed Honest >> wrote: >> >> Dear, >> >> >> >> I think using Ctrl + Z will allow you to take back the action you >> performed i.e Undo the last action ;-). This should help. If not, check >> other experts advice. >> >> >> >> Thanks, >> >> >> >> >> >> >> >> On Wed, Jun 27, 2012 at 12:33 PM, Muralidhar E >> wrote: >> >> >> Dear all, >> >> >> >> Iam using Office 2007, when iam need to use Crl+F accidently iam hitting >> Ctrl+D, iam loosing some data and iam unable to find the changes happening >> to the data file. >> >> Iam want to disable Ctrl+D option with a passward and the same enable >> with passward, it should for that worksheet only. >> >> >> >> Thanks in advance. >> -- >> >> *Thanks & Regards,* >> >> >> >> *Muralidhar E.* >> >> ** ** >> >> -- >> -- >> 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 >> >> To unsubscribe, send a blank email to >> excel-macros+unsubscr...@googlegroups.com >> >> >> >> >> >> >> >> -- >> >> Ahmed Bawazir >> >> *احمد باوزير* >> >> ** ** >> >> >> >> >> -- >> >> *Thanks & Regards,* >> >> >> >> *Muralidhar E.* >> >> ** ** >> >> -- >> -- >> 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.
RE: $$Excel-Macros$$ Enable & Disable Ctrl+D with passward
HI HTH Sub DisableCtrlD() Dim blnflag As Boolean Dim strPwd As String strPwd = Application.InputBox("Enter the Password ", "Password") blnflag = Application.InputBox("To Enable Key Press 1 and To disable press 0 ", "Password") If strPwd = "GiveYourPwd" Then If blnflag Then Application.OnKey "^d", "" Else Application.OnKey "^d", "Test" End If End If End Sub Sub Test() MsgBox "Disabled" End Sub Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Muralidhar E Sent: 29 June 2012 10:08 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Enable & Disable Ctrl+D with passward Hi gm experts, is anybody solve my problem reg. disable ctrl+d option. Iam waiting for solution for the problem. On Thu, Jun 28, 2012 at 2:34 PM, Muralidhar E wrote: Hi group, Because of CTRl+D just fill down the data iam facing this problem, when i want to use Ctrl+F unfortunatley it was accidently clicking Ctrl+D iam not observing it later it was effecting to the data. So i what i need is i want to disable Ctrl+D with a passward and same time i want to enable with a passward. I think it will usefull for others also. Thanks in Advance. On Wed, Jun 27, 2012 at 6:38 PM, Rajan_Verma wrote: Do you have any add-in or macro in personal.xlsb which have any macro assigned Ctrl+D?? Because excel default Ctrl+D just fill down the data. Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Muralidhar E Sent: 27 June 2012 3:18 To: excel-macros@googlegroups.com Cc: ahmedhon...@gmail.com Subject: Re: $$Excel-Macros$$ Enable & Disable Ctrl+D with passward Hi, But it will not come to the notice at the same time, it was accidently going on, iam not observing it later it was effecting to the data. On Wed, Jun 27, 2012 at 3:09 PM, Ahmed Honest wrote: Dear, I think using Ctrl + Z will allow you to take back the action you performed i.e Undo the last action ;-). This should help. If not, check other experts advice. Thanks, On Wed, Jun 27, 2012 at 12:33 PM, Muralidhar E wrote: Dear all, Iam using Office 2007, when iam need to use Crl+F accidently iam hitting Ctrl+D, iam loosing some data and iam unable to find the changes happening to the data file. Iam want to disable Ctrl+D option with a passward and the same enable with passward, it should for that worksheet only. Thanks in advance. -- Thanks & Regards, Muralidhar E. -- -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com <mailto:excel-macros%2bunsubscr...@googlegroups.com> -- Ahmed Bawazir احمد باوزير -- Thanks & Regards, Muralidhar E. -- -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- -- FORUM RULES (986+ members already BANNED fo
Re: $$Excel-Macros$$ Enable & Disable Ctrl+D with passward
Hi, Rajan, thanks alot. Warm Ragards, Muralidhar E On Sat, Jun 30, 2012 at 10:09 AM, Rajan_Verma wrote: > HI > > ** ** > > HTH > > ** ** > > Sub DisableCtrlD() > > > > Dim blnflag As Boolean > > Dim strPwd As String > > > > strPwd = Application.InputBox("Enter the Password ", "Password") > > blnflag = Application.InputBox("To Enable Key Press 1 and To disable > press 0 ", "Password") > > > > If strPwd = "GiveYourPwd" Then > > If blnflag Then > > Application.OnKey "^d", "" > > Else > > Application.OnKey "^d", "Test" > > End If > > End If > > End Sub > > ** ** > > Sub Test() > > MsgBox "Disabled" > > End Sub > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Muralidhar E > *Sent:* 29 June 2012 10:08 > *To:* excel-macros@googlegroups.com > > *Subject:* Re: $$Excel-Macros$$ Enable & Disable Ctrl+D with passward > > ** ** > > Hi gm experts, > > > > is anybody solve my problem reg. disable ctrl+d option. > > Iam waiting for solution for the problem. > > > > > > On Thu, Jun 28, 2012 at 2:34 PM, Muralidhar E > wrote: > > Hi group, > > > > Because of CTRl+D just fill down the data iam facing this problem, when i > want to use Ctrl+F unfortunatley it was accidently clicking Ctrl+D iam not > observing it later it was effecting to the data. > > So i what i need is i want to *disable Ctrl+D with a passward* and > same time i want to *enable with a passward*. > > > > I think it will usefull for others also. > > > > Thanks in Advance. > > > > > > On Wed, Jun 27, 2012 at 6:38 PM, Rajan_Verma > wrote: > > Do you have any add-in or macro in personal.xlsb which have any macro > assigned Ctrl+D??**** > > Because excel default Ctrl+D just fill down the data. > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Muralidhar E > *Sent:* 27 June 2012 3:18 > *To:* excel-macros@googlegroups.com > *Cc:* ahmedhon...@gmail.com > > > *Subject:* Re: $$Excel-Macros$$ Enable & Disable Ctrl+D with passward > > > > > Hi, > > > > But it will not come to the notice at the same time, it was accidently > going on, iam not observing it later it was effecting to the data. > > > > > On Wed, Jun 27, 2012 at 3:09 PM, Ahmed Honest > wrote: > > Dear, > > > > I think using Ctrl + Z will allow you to take back the action you > performed i.e Undo the last action ;-). This should help. If not, check > other experts advice. > > > > Thanks, > > > > > > > > On Wed, Jun 27, 2012 at 12:33 PM, Muralidhar E > wrote: > > > Dear all, > > > > Iam using Office 2007, when iam need to use Crl+F accidently iam hitting > Ctrl+D, iam loosing some data and iam unable to find the changes happening > to the data file. > > Iam want to disable Ctrl+D option with a passward and the same enable with > passward, it should for that worksheet only. > > > > Thanks in advance. > -- > > *Thanks & Regards,* > > > > *Muralidhar E.* > > > > -- > -- > 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. > > > -
Re: $$Excel-Macros$$ Enable & Disable Ctrl+D with passward
Hi, Can u guide the procedure how to run this code in my file. I am fail to run the code. Warm Regards, Muralidhar E. On Sat, Jun 30, 2012 at 10:25 AM, Muralidhar E wrote: > > Hi, > > Rajan, > > thanks alot. > Warm Ragards, > > Muralidhar E > On Sat, Jun 30, 2012 at 10:09 AM, Rajan_Verma > wrote: > >> HI >> >> ** ** >> >> HTH >> >> ** ** >> >> Sub DisableCtrlD() >> >> >> >> Dim blnflag As Boolean >> >> Dim strPwd As String >> >> >> >> strPwd = Application.InputBox("Enter the Password ", "Password") >> >> blnflag = Application.InputBox("To Enable Key Press 1 and To disable >> press 0 ", "Password") >> >> >> >> If strPwd = "GiveYourPwd" Then >> >> If blnflag Then >> >> Application.OnKey "^d", "" >> >> Else >> >> Application.OnKey "^d", "Test" >> >> End If >> >> End If >> >> End Sub >> >> ** ** >> >> Sub Test()**** >> >> MsgBox "Disabled" >> >> End Sub >> >> * * >> >> *Regards* >> >> *Rajan verma* >> >> *+91 7838100659 [IM-Gtalk]* >> >> ** ** >> >> *From:* excel-macros@googlegroups.com [mailto: >> excel-macros@googlegroups.com] *On Behalf Of *Muralidhar E >> *Sent:* 29 June 2012 10:08 >> *To:* excel-macros@googlegroups.com >> >> *Subject:* Re: $$Excel-Macros$$ Enable & Disable Ctrl+D with passward >> >> ** ** >> >> Hi gm experts, >> >> >> >> is anybody solve my problem reg. disable ctrl+d option. >> >> Iam waiting for solution for the problem. >> >> >> >> >> >> On Thu, Jun 28, 2012 at 2:34 PM, Muralidhar E >> wrote: >> >> Hi group, >> >> >> >> Because of CTRl+D just fill down the data iam facing this problem, when i >> want to use Ctrl+F unfortunatley it was accidently clicking Ctrl+D iam not >> observing it later it was effecting to the data. >> >> So i what i need is i want to *disable Ctrl+D with a passward* and >> same time i want to *enable with a passward*. >> >> >> >> I think it will usefull for others also. >> >> >> >> Thanks in Advance. >> >> >> >> >> >> On Wed, Jun 27, 2012 at 6:38 PM, Rajan_Verma >> wrote: >> >> Do you have any add-in or macro in personal.xlsb which have any macro >> assigned Ctrl+D?? >> >> Because excel default Ctrl+D just fill down the data. >> >> * * >> >> *Regards* >> >> *Rajan verma* >> >> *+91 7838100659 [IM-Gtalk]* >> >> >> >> *From:* excel-macros@googlegroups.com [mailto: >> excel-macros@googlegroups.com] *On Behalf Of *Muralidhar E >> *Sent:* 27 June 2012 3:18 >> *To:* excel-macros@googlegroups.com >> *Cc:* ahmedhon...@gmail.com >> >> >> *Subject:* Re: $$Excel-Macros$$ Enable & Disable Ctrl+D with passward >> >> >> >> >> Hi, >> >> >> >> But it will not come to the notice at the same time, it was accidently >> going on, iam not observing it later it was effecting to the data. >> >> >> >> >> On Wed, Jun 27, 2012 at 3:09 PM, Ahmed Honest >> wrote: >> >> Dear, >> >> >> >> I think using Ctrl + Z will allow you to take back the action you >> performed i.e Undo the last action ;-). This should help. If not, check >> other experts advice. >> >> >> >> Thanks, >> >> >> >> >> >> >> >> On Wed, Jun 27, 2012 at 12:33 PM, Muralidhar E >> wrote: >> >> >> Dear all, >> >> >> >> Iam using Office 2007, when iam need to use Crl+F accidently iam hitting >> Ctrl+D, iam loosing some data and iam unable to find the changes happening >> to the data file. >> >> Iam want to disable Ctrl+D option with a passward and the same enable >> with passward, it should for that worksheet onl
RE: $$Excel-Macros$$ Enable & Disable Ctrl+D with passward
HI First you need to give your password in code (Replace “GiveYourPwd” with your password”) , Press ALT +F 11 then Insert a Module , paste the code there, come to the worksheet and Just Press Alt+F8 and select DisableCtrlD , Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Muralidhar E Sent: 30 June 2012 10:48 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Enable & Disable Ctrl+D with passward Hi, Can u guide the procedure how to run this code in my file. I am fail to run the code. Warm Regards, Muralidhar E. On Sat, Jun 30, 2012 at 10:25 AM, Muralidhar E wrote: Hi, Rajan, thanks alot. Warm Ragards, Muralidhar E On Sat, Jun 30, 2012 at 10:09 AM, Rajan_Verma wrote: HI HTH Sub DisableCtrlD() Dim blnflag As Boolean Dim strPwd As String strPwd = Application.InputBox("Enter the Password ", "Password") blnflag = Application.InputBox("To Enable Key Press 1 and To disable press 0 ", "Password") If strPwd = "GiveYourPwd" Then If blnflag Then Application.OnKey "^d", "" Else Application.OnKey "^d", "Test" End If End If End Sub Sub Test() MsgBox "Disabled" End Sub Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Muralidhar E Sent: 29 June 2012 10:08 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Enable & Disable Ctrl+D with passward Hi gm experts, is anybody solve my problem reg. disable ctrl+d option. Iam waiting for solution for the problem. On Thu, Jun 28, 2012 at 2:34 PM, Muralidhar E wrote: Hi group, Because of CTRl+D just fill down the data iam facing this problem, when i want to use Ctrl+F unfortunatley it was accidently clicking Ctrl+D iam not observing it later it was effecting to the data. So i what i need is i want to disable Ctrl+D with a passward and same time i want to enable with a passward. I think it will usefull for others also. Thanks in Advance. On Wed, Jun 27, 2012 at 6:38 PM, Rajan_Verma wrote: Do you have any add-in or macro in personal.xlsb which have any macro assigned Ctrl+D?? Because excel default Ctrl+D just fill down the data. Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Muralidhar E Sent: 27 June 2012 3:18 To: excel-macros@googlegroups.com Cc: ahmedhon...@gmail.com Subject: Re: $$Excel-Macros$$ Enable & Disable Ctrl+D with passward Hi, But it will not come to the notice at the same time, it was accidently going on, iam not observing it later it was effecting to the data. On Wed, Jun 27, 2012 at 3:09 PM, Ahmed Honest wrote: Dear, I think using Ctrl + Z will allow you to take back the action you performed i.e Undo the last action ;-). This should help. If not, check other experts advice. Thanks, On Wed, Jun 27, 2012 at 12:33 PM, Muralidhar E wrote: Dear all, Iam using Office 2007, when iam need to use Crl+F accidently iam hitting Ctrl+D, iam loosing some data and iam unable to find the changes happening to the data file. Iam want to disable Ctrl+D option with a passward and the same enable with passward, it should for that worksheet only. Thanks in advance. -- Thanks & Regards, Muralidhar E. -- -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com <mailto:excel-macros%2bunsubscr...@googlegroups.com> -- Ahmed Bawazir احمد باوزير -- Thanks & Regards, Muralidhar E. -- -- 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, C
Re: $$Excel-Macros$$ Enable & Disable Ctrl+D with passward
hi, If strPwd = "GiveYourPwd" Then i change here as 143 macros is running but for enabling ctrl+d it is not working. On Sat, Jun 30, 2012 at 10:51 AM, Rajan_Verma wrote: > HI > > ** ** > > First you need to give your password in code (Replace “GiveYourPwd” with > your password”) , Press ALT +F 11 then Insert a Module , paste the code > there, come to the worksheet and > > Just Press Alt+F8 and select DisableCtrlD , > > ** ** > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Muralidhar E > *Sent:* 30 June 2012 10:48 > > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Enable & Disable Ctrl+D with passward > > ** ** > > Hi, > > > > Can u guide the procedure how to run this code in my file. > > I am fail to run the code. > > Warm Regards, > > > > Muralidhar E. > > On Sat, Jun 30, 2012 at 10:25 AM, Muralidhar E > wrote: > > > Hi, > > > > Rajan, > > > > thanks alot. > > Warm Ragards, > > > > Muralidhar E > > On Sat, Jun 30, 2012 at 10:09 AM, Rajan_Verma > wrote: > > HI > > > > HTH > > > > Sub DisableCtrlD() > > > > Dim blnflag As Boolean > > Dim strPwd As String > > > > strPwd = Application.InputBox("Enter the Password ", "Password") > > blnflag = Application.InputBox("To Enable Key Press 1 and To disable > press 0 ", "Password") > > > > If strPwd = "GiveYourPwd" Then > > If blnflag Then > > Application.OnKey "^d", "" > > Else > > Application.OnKey "^d", "Test" > > End If > > End If**** > > End Sub**** > > > > Sub Test() > > MsgBox "Disabled" > > End Sub > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Muralidhar E > *Sent:* 29 June 2012 10:08 > *To:* excel-macros@googlegroups.com > > > *Subject:* Re: $$Excel-Macros$$ Enable & Disable Ctrl+D with passward > > > > Hi gm experts, > > > > is anybody solve my problem reg. disable ctrl+d option. > > Iam waiting for solution for the problem. > > > > > > On Thu, Jun 28, 2012 at 2:34 PM, Muralidhar E > wrote: > > Hi group, > > > > Because of CTRl+D just fill down the data iam facing this problem, when i > want to use Ctrl+F unfortunatley it was accidently clicking Ctrl+D iam not > observing it later it was effecting to the data. > > So i what i need is i want to *disable Ctrl+D with a passward* and > same time i want to *enable with a passward*. > > > > I think it will usefull for others also. > > > > Thanks in Advance.**** > > > > > > On Wed, Jun 27, 2012 at 6:38 PM, Rajan_Verma > wrote: > > Do you have any add-in or macro in personal.xlsb which have any macro > assigned Ctrl+D?? > > Because excel default Ctrl+D just fill down the data. > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Muralidhar E > *Sent:* 27 June 2012 3:18 > *To:* excel-macros@googlegroups.com > *Cc:* ahmedhon...@gmail.com > > > *Subject:* Re: $$Excel-Macros$$ Enable & Disable Ctrl+D with passward > > > > > Hi, > > > > But it will not come to the notice at the same time, it was accidently > going on, iam not observing it later it was effecting to the data. > > > > > On Wed, Jun 27, 2012 at 3:09 PM, Ahmed Honest > wrote: > > Dear, > > > > I think using Ctrl + Z will allow you to take back the action you > performed i.e Undo the last action ;-). This should help. If not, check > other experts advice. > > > > Thanks, > > > > > > > > On Wed, Jun 27, 2012 at 12:33 PM, Muralidhar E