'Alt+' Macro Question

I know it's possible and I've read a few different ways to go about it but I can't seem to get them to work.
What I'm trying to do is run an 'Undo' function whenever I hit Alt+'Left Arrow key'
Even if it's just Ctrl+z is ran when I hit Alt+'Left Arrow key' I'm not picky.

For some perspective, I have a macro button on my mouse that I set to, what the editing software that came with the mouse calls, "IE Back," and that's exactly what I want it to do. I was just hoping to figure out a way that when my excel window is selected, when I hit the macro "IE Back" button, it commands an edit undo function instead.
To be honest I'm not sure if the "IE Back" button's code is actually written as Alt+'Left Arrow key' but that was my first assumption. If its not I can obviously just write a custom macro to my mouse replacing the pre-written "IE Back" macro.

Anyway I'd appreciate any help or incite on the question and thanks.

Hi,

The following code will UNDO once. After the UNDO is executed the UNDO stack is apparently cleared.

Please Login or Register  to view this content.

The following article explains how to do multiple UNDOs. http://j-walk.com/ss/excel/tips/tip23.htm

Lewis

So I have put this in a personal module and saved it but it's not working yet. Do I have to change the name or do something else first?

You have to run Macro EnableAltLeftArrowKey() to start it up.

You can put the following in the ThisWorkBook Module of your file to automatically start it when the workbook is opened:

Please Login or Register  to view this content.

Lewis

Ok, yeah that's what I was afraid of. So I'd have to hit an assigned hotkey first to enable the macro, and it's not until then that I could use Alt+Left Arrow, correct?
I have it in my VBAProject (Personal.xlsb) so I believe it applies to all workbooks. So would I insert the "Option Explicit...." code at the start of the original code (before "Sub EnableAltLeftArrowKey()..."), or would I put it the "Sub EnableAltLeftArrowKey()..." in between "Private Sub Workbook_Open" and "Private Sub Workbook_BeforeClose(Cancel As Boolean)"

Sorry, I took C++ as a Freshman in College so I can for the most part follow someone else's written code, not the best at writing it without help, but I obviously struggle at implementing it the most.

Oh.. I didn't read when you said ThisWorkBook right. My brain just "in ThisWorkBook" thinking you were referring to whatever the name of my workbook is, instead of "in the ThisWorkBook"..

So I got the Alt+Left Arrow to work, unfortunately that must not be how CoolerMaster writes their "IE Back" program in their mice software..