Hi,
To really change the key assignments for the Alt+155 combination, I suspect
you would need to do it outside Excel, and it would apply throught all
Windows programs.
However, why not assign the symbol to a simplier shortcut key combination
like Ctrl+e or Ctrl+Shift+C
You can do key assignments in Excel but they are only prepared to handle a
single key or a key in combination with Shift, Alt, or Ctrl.
Here is the code to enter the cent symbol in the active cell.
Sub Cents()
ActiveCell = "¢"
End Sub
You can assign a shortcut key once you have put this code in a module.
Move back to Excel and choose Tools, Macro, Macros. Select the Cents macro
and click Options. In here hold down the Shift key and press the letter you
want to assign or just type the letter without the Shift key.
If you want the shortcut key available in all the workbooks you open put the
code in the Personal Macro Workbook.
The easiest way to do this is to choose Tools, Macro, Record new macro,
Enter the name Cents and from the drop down for Store macros in pick Personal
Macro Workbook. Click OK. Choose Insert, Symbols, Normal text, find and
select the cent sign, click the Insert button and then the Close button and
press Enter. Stop the recorder by choosing Tools, Macro, Stop Recording.
You have added the macro to the file, assign the shortcut key as described
above. And when you close out of Excel, respond Yes to saving the changes to
the Personal.xls file.
