Using Excel 2000
I have a macro in "Personal.xls" to paste the value only of the clipboard.
Sub PasteValue()
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
End Sub
The assigned shortcut is Cntl-Shift-V
When running in Win98, the shortcut work regardless of CapsLock position.
When running in WinXP, the shortcut only works with CapsLock OFF.
Can I make the shortcut work in XP like it does in 98 ?
If this is the wrong forum, please redirect me.
Thanks much.