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?
|