So here is my question. No idea if its possible, but is there a way to
create a macro that can be turned on and off that when it is on it can make a
certain key (lets say the Q key) actually work like the equals key? I am
going back and forth between the tab key and equals key a whole lot and would
be easier if i could just leave my hand in one place. I hope it can be done..

Maybe you could *temporarily* set AutoCorrect to replace q with =.

Biff

"brownti via OfficeKB.com" <u31540@uwe wrote in message
news:6dce4f0097d1a@uwe...
So here is my question. No idea if its possible, but is there a way to
create a macro that can be turned on and off that when it is on it can
make a
certain key (lets say the Q key) actually work like the equals key? I am
going back and forth between the tab key and equals key a whole lot and
would
be easier if i could just leave my hand in one place. I hope it can be
done..

I like the idea, but doesnt work...just wishful thinking i guess


T. Valko wrote:
Maybe you could *temporarily* set AutoCorrect to replace q with =.

Biff

So here is my question. No idea if its possible, but is there a way to
create a macro that can be turned on and off that when it is on it can
[quoted text clipped - 4 lines]
be easier if i could just leave my hand in one place. I hope it can be
done..

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200702/1

I recorded a macro quick and set it to come on with ctrl-q, it then sets auto
correct to change q to =, then another with ctrl-w to change it back, it
looks like this

Sub Macro1()
'
'
' Keyboard Shortcut: Ctrl+q
'
Application.AutoCorrect.AddReplacement What:="q", Replacement:="="
With Application.AutoCorrect
.TwoInitialCapitals = True
.CorrectSentenceCap = True
.CapitalizeNamesOfDays = True
.CorrectCapsLock = True
.ReplaceText = True
.DisplayAutoCorrectOptions = True
End With

End Sub
Sub Macro2()

'
' Keyboard Shortcut: Ctrl+w
'
Application.AutoCorrect.DeleteReplacement What:="q"
With Application.AutoCorrect
.TwoInitialCapitals = True
.CorrectSentenceCap = True
.CapitalizeNamesOfDays = True
.CorrectCapsLock = True
.ReplaceText = True
.DisplayAutoCorrectOptions = True
End With
End Sub
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"brownti via OfficeKB.com" wrote:

So here is my question. No idea if its possible, but is there a way to
create a macro that can be turned on and off that when it is on it can make a
certain key (lets say the Q key) actually work like the equals key? I am
going back and forth between the tab key and equals key a whole lot and would
be easier if i could just leave my hand in one place. I hope it can be done..