Hi, Very sorry repeating the mail, iam unable to find the code to copy at my original file. Message run-time error 1004 Method onkey of object_application failed.
Thanks in advance -- *Thanks & Regards,* ** *Muralidhar E.* On Sat, Mar 31, 2012 at 3:20 PM, Abhishek Jain <abhishek....@gmail.com>wrote: > There was no code in this one under "ThisWorkbook" object. Please find > attached the updated file which is working fine. > > HTH > > > On Sat, Mar 31, 2012 at 3:09 PM, muralidhar e <emuralidha...@gmail.com>wrote: > >> >> Hi Abhishek, >> Find the attached file, and the passward for macro is 151176. >> >> Thanks in advance. >> ** >> *Thanks & Regards,* >> ** >> *Muralidhar E.* >> >> On Sat, Mar 31, 2012 at 2:32 PM, Abhishek Jain >> <abhishek....@gmail.com>wrote: >> >>> I tested those and working fine even after closing and reopening the >>> workbook. Can you share your sample file which is giving problem? >>> >>> >>> On Sat, Mar 31, 2012 at 2:22 PM, muralidhar e >>> <emuralidha...@gmail.com>wrote: >>> >>>> Hi Abhishek, >>>> >>>> Its working fine, but when iam closed the file and reopen it is not >>>> working. >>>> >>>> Thanks in Advance. >>>> >>>> >>>> >>>> >>>> >>>> >>>> On Sat, Mar 31, 2012 at 1:29 PM, Abhishek Jain >>>> <abhishek....@gmail.com>wrote: >>>> >>>>> Dear Muralidhar, >>>>> >>>>> To my knowledge, there is not a direct way to disable a shortcut >>>>> without using VBA. If you are still interested, read on. >>>>> >>>>> To disable, we can use this line - Application.OnKey "^d", "" >>>>> To enable it again - Application.OnKey "^d" >>>>> >>>>> Now to make them work them unattended we can use as following - >>>>> >>>>> Choose to disable it upon opening of the workbook - >>>>> >>>>> *Private Sub Workbook_Open()* >>>>> *Application.OnKey "^d", ""* >>>>> *End Sub* >>>>> >>>>> Choose to re-enable it before close of the workbook so that it doesn't >>>>> mess with other files - >>>>> >>>>> *Private Sub Workbook_BeforeClose(Cancel As Boolean)* >>>>> *Application.OnKey "^d"* >>>>> *End Sub* >>>>> >>>>> You can copy-paste both these 02 codes in code area for "ThisWorkbook" >>>>> object. >>>>> >>>>> HTH >>>>> >>>>> Abhishek >>>>> >>>>> On Sat, Mar 31, 2012 at 12:03 PM, muralidhar e < >>>>> emuralidha...@gmail.com> wrote: >>>>> >>>>>> >>>>>> hi dear group members, >>>>>> >>>>>> Good afternoon >>>>>> >>>>>> Iam using excel-2007 & 2010, with a huge data, with this when iam >>>>>> suppose to use Ctrl+F for find the batches by overlook when iam pressing >>>>>> ctrl+F iam pressing Ctrl+D. In this case the data is changing. >>>>>> >>>>>> I want to disable the Ctl+D option, it is very better useful it we >>>>>> not use Macros. >>>>>> >>>>>> 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 >>>>>> >>>>> >>>>> >>>> >>>> >>>> >>> >> >> >> > -- 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
