Depending on what you want to do - a fairly simple solution would be to have wrap the rest of the macro in a big If statement, so that it only runs if certain criteria are met - or you could use an inputbox or something along those lines.
For example:
Code:
Dim strInput as String
strInput=InputBox "Enter some text"
If strInput="YourText" Then
DoTheRestOfTheMacro
End If
Steven
I am a loud man with a very large hat. This means I am in charge
How do I disable a key in vba for word?
