How to delete shortcuts

[HBomberMan]

Hi,

I’ve got some spreadsheets that contain macros that I would like to delete. The reason I want to delete them is that the shortcut keys are really annoying, for example every time I use CTRL+F it tries to run a macro and I get an error message, “The macro xxxxxxxxx could not be found”.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
I have looked in the ALT+F8 menu and I can see the macros in there but when I click on them I get an error saying “Reference not valid”.
<o> </o>
I have also checked every sheet of every open workbook (and my personal workbook) in the
VBA window but I cannot see a single line of code!!
<o> </o>
I have tried changing the shortcut keys but every time I restart my machine they come back!
<o> </o>
It seems to me that the macros were a legacy from older versions of the spreadsheets and have been deleted but for some reason the shortcuts are still there.
<o> </o>
Does anyone know how I can delete these shortcuts once and for all??!
<o> </o>
<o>I'm using Excel 2003 btw.</o>
Many thanks in advance for your help.
Phil

 

[John Davis]

Hi,

I’ve got some spreadsheets that contain macros that I would like to delete. The reason I want to delete them is that the shortcut keys are really annoying, for example every time I use CTRL+F it tries to run a macro and I get an error message, “The macro xxxxxxxxx could not be found”.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
I have looked in the ALT+F8 menu and I can see the macros in there but when I click on them I get an error saying “Reference not valid”.
<o> </o>
I have also checked every sheet of every open workbook (and my personal workbook) in the
VBA window but I cannot see a single line of code!!
<o> </o>
I have tried changing the shortcut keys but every time I restart my machine they come back!
<o> </o>
It seems to me that the macros were a legacy from older versions of the spreadsheets and have been deleted but for some reason the shortcuts are still there.
<o> </o>
Does anyone know how I can delete these shortcuts once and for all??!
<o> </o>
<o>I'm using Excel 2003 btw.</o>
Many thanks in advance for your help.
Phil

Can this be of any help?

http://www.excelbanter.com/showthread.php?t=17420

 

[shg]

I can see the macros in there

What workbook are they in? If not in the active workbook, the workbook name will appear in the box.

What happens if you select one and click Edit?