Hi,
Try it,
Private Sub Workbook_Open()
Application.OnKey "^d", ""
End Sub
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.OnKey "^d"
End Sub
On Tue, Apr 17, 2012 at 3:36 AM, muralidhar e wrote:
>
> hi, anil
>
> Iam not understand, if u not feel can u explain it.
>
> *Iam wha
hi, anil
Iam not understand, if u not feel can u explain it.
*Iam what i need is simply is.*
iam need not want Ctrl+D option and it disable in my worksheet. if i
suppose to use the Ctrl+D option i need a passward when i am using the
Ctrl+D.
Thanks
Muralidhar E
On Tue, Apr 17, 2012 at 3:11
Hi
Please Use alt + ctrl + L then Ctrl D
On Tue, Apr 17, 2012 at 3:07 PM, muralidhar e 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
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 wrote:
> There was
There was no code in this one under "ThisWorkbook" object. I have sent the
updated file which is working fine on your personal ID.
HTH
> On Sat, Mar 31, 2012 at 3:09 PM, muralidhar e wrote:
>
>>
>> Hi Abhishek,
>> Find the attached file, and the passward for macro is 151176.
>>
>> Thanks in ad
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 wrote:
> Hi Abhishek,
>
> Its working fine, but when iam closed the file and reopen it is not
> working.
>
> Thanks
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 wrote:
> Dear Muralidhar,
>
> To my knowledge, there is not a direct way to disable a shortcut without
> using VBA. If you are still i
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
