Solved

Excel Help, need TradeMark symbol

Posted on 1999-01-14
9
537 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
 
LVL 10

Expert Comment

by:MasseyM
ID: 1615693
Man cartii what is your problem.  READ WHAT I TYPED!
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
EXCEL 2010 7 57
Word - Access 3 49
How to have Excel 2010 & Excel 2016 both installed, but Excel 2010 as default? 2 43
Microsoft Edge, Outlook OWA 7 45
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
Outlook Free & Paid Tools
This video shows and describes the main difference between both orientations in Microsoft Word. Viewers will understand when to use each orientation and how to get the most out of them.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…

864 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now