DisableDelete??? cannot use delete key

funtoos

New Member
Joined
Sep 16, 2011
Messages
3
When I try to use delete key, I get this error
Cannot run the macro "C:\Documents and Settings\xxx\ApplicationData\Microsoft\Excel\XLSTART\PERSONAL.XLSB'!DisableDelete'. The macro may not be available in this workbook or all may be disabled.
I have trying to learn from the book "VBA and Macros". All are macros working.
Please help!!!
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
Hallo

quote:Cannot run the macro
You may delete or remove from the file path: ("C:\Documents and Settings\xxx\ApplicationData\Microsoft\Excel\XLSTART\PERSONAL.XLSB") using excel and you will not have the problem, while if the file has other activities necessary macro you could restore the command Canc.

'This example restores the Delete command

Code:
Sub Ripristina()
    Application.OnKey "{DEL}"
End Sub
While you should correct the code if you want to have the original file that created "PERSONAL.XLSB"
 
Upvote 0
Thanks for the reply. I was waiting patiently for response.
I have few question before I use it (please don't misunderstand...)
1. I have not written any macro by the name DisableDelete.
2. I have 9 - 10 custom macros in Personal.XLSB - what about these macros if i delete the personal.XLSB file.
3. how can I correct the code if I want to have the original file.

Please help with these queries, I terrified with the thought of re-install.... Please save me!!!
 
Upvote 0

Forum statistics

Threads
1,224,524
Messages
6,179,310
Members
452,906
Latest member
phanmemchatdakenhupviral

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top