Tracing and reassigning macro short cut keys

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have inherited a very useful spreadsheet that automatically loads when
excel starts and remains hidden, operating in the background.

Unfortunately, their is a useless macro assigned the Ctrl + z shortcut which
means we cannot use it for the undo function.

Is it possible to find out which macros have shortcuts assigned to them and
can I reassign ctrl + z back to undo? Or will it revert automatically when I
delete the macro?
 
it will automatically revert once you delete it
to find out which macro it is i would open up VBA and do a search in the
entire project for 'Ctrl+z' If the macro was recorded this might be in a
comment line, you can then delete that macro.
 
If you can't find the assigned values that way, you may want to manually
look. Hit alt+F8 and then select each macro and then look at the 'options'.
This can tell you if a hotkey is assigned to a specific macro. You can
delete it here as well.
 
Back
Top