Tracing and reassigning macro short cut keys
 

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?

Tracing and reassigning macro short cut keys
 

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.


"Graeme" wrote:

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?