• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 557
  • Last Modified:

Excel Help, need TradeMark symbol

besides typing "ALT+0153" or whatever the combo is. how can i set a single key or make a macro or something to produce the trademark symbol?

thanks,
  pipe
0
pipe
Asked:
pipe
1 Solution
 
bushheadCommented:
not sure about a single key.. but u can type (tm) to make the trademark sign..

bush
0
 
MasseyMCommented:
Record a macro that will type the (tm) characters in the cell.  
0
 
carttiCommented:
Type this macro:

Sub Test()
   SendKeys "™"
End Sub

Then assign this macro to a hotkey. To do this, go to Tools-Macro-Macros...  then select "Test" (name referring to the above macro) then options, and choose the key you want to press along side the Ctrl button to activate the macro.
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
MasseyMCommented:
Man cartii what is your problem.  READ WHAT I TYPED!
0
 
carttiCommented:
What are you talking about!

Recording a macro to do that will mean the ™ character appears in the cell you typed it in. I suggested a far more flexible approach.

You did not mention anything about the Sendkeys function and nothing about hotkeys. So what is YOUR problem.
0
 
carttiCommented:
MasseyM - get my handle right too! Spelt c a r t t i
0
 
MasseyMCommented:
sorry... wasn't paying attention... my macro is designed to insert the tm whenever the character combo of the macro is pressed :)  I apologize for mispelling your handle.  Have a nice day.
0
 
carttiCommented:
No worries.
0
 
pipeAuthor Commented:
rofl
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now