Solved

Excel Help, need TradeMark symbol

Posted on 1999-01-14
9
539 Views
Last Modified: 2008-02-26
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
Comment
Question by:pipe
9 Comments
 
LVL 2

Expert Comment

by:bushhead
ID: 1615690
not sure about a single key.. but u can type (tm) to make the trademark sign..

bush
0
 
LVL 10

Expert Comment

by:MasseyM
ID: 1615691
Record a macro that will type the (tm) characters in the cell.  
0
 
LVL 2

Accepted Solution

by:
cartti earned 70 total points
ID: 1615692
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
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
LVL 10

Expert Comment

by:MasseyM
ID: 1615693
Man cartii what is your problem.  READ WHAT I TYPED!
0
 
LVL 2

Expert Comment

by:cartti
ID: 1615694
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
 
LVL 2

Expert Comment

by:cartti
ID: 1615695
MasseyM - get my handle right too! Spelt c a r t t i
0
 
LVL 10

Expert Comment

by:MasseyM
ID: 1615696
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
 
LVL 2

Expert Comment

by:cartti
ID: 1615697
No worries.
0
 

Author Comment

by:pipe
ID: 1615698
rofl
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Have you ever had the experience that you had to follow 10 steps over and over again every time when you need to nicely forward an important email to your manager? Fear no more! With the help of the Quick Steps feature in Outlook 2010, your old chor…
Problem: You created a new custom form in Outlook for your contacts (added fields, deleted fields, changed the layout of fields, whatever) and made it the default form for contacts. The good news is that all new contacts will utilize the new form. T…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question