Prevent e-mail entrys from linking

I have need for entering multiple e-mails in a worksheet.  While all
automatically link, there are places where I do not want the links to
take place--ever.  Is there a way to prevent links in designated
cells?  Also, the cells are merged if that makes a difference.  Thanks
in advance.

Michael
0
7/8/2009 5:01:21 PM
excel 39879 articles. 2 followers. Follow

5 Replies
366 Views

Similar Articles

[PageSpeed] 34

Hi,

right click and choose remove hyperlink.

or for more than one cell - click an empty cell choose copy, select all the 
hyperlinks you want removed and choose Edit, Paste Special, Add.
-- 
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Michael Lanier" wrote:

> I have need for entering multiple e-mails in a worksheet.  While all
> automatically link, there are places where I do not want the links to
> take place--ever.  Is there a way to prevent links in designated
> cells?  Also, the cells are merged if that makes a difference.  Thanks
> in advance.
> 
> Michael
> 
0
7/8/2009 5:09:01 PM
Shane,

The only problem is that when I enter another e-mail address later, it
too once again links.  I'm hoping to unlink the applicable cell once
and for all without affecting other cells within the workbook.  Thanks
for your help.

Michael
0
7/8/2009 5:43:32 PM
Hi,

Your option is a VBA macro.

Private Sub Worksheet_Change(ByVal Target As Range)
    Dim isect As Range
    Application.EnableEvents = False
    Set isect = Application.Intersect(Target, Range("A1,C1"))
    If Not isect Is Nothing Then
        [IV65536].Copy
        Target.PasteSpecial Paste:=xlPasteAll, Operation:=xlAdd
    End If
    Application.EnableEvents = True
End Sub


-- 
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Michael Lanier" wrote:

> Shane,
> 
> The only problem is that when I enter another e-mail address later, it
> too once again links.  I'm hoping to unlink the applicable cell once
> and for all without affecting other cells within the workbook.  Thanks
> for your help.
> 
> Michael
> 
0
7/8/2009 7:37:01 PM
Hi,

I should add - The code goes into the sheet object in the VBE:

1. To add this code to your file, press Alt+F11,  
2.  In the VBAProject window, top left side, find your sheet name under your 
file name and double click it.
3.  Paste in or type the code above. 

-- 
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Michael Lanier" wrote:

> Shane,
> 
> The only problem is that when I enter another e-mail address later, it
> too once again links.  I'm hoping to unlink the applicable cell once
> and for all without affecting other cells within the workbook.  Thanks
> for your help.
> 
> Michael
> 
0
7/8/2009 7:40:01 PM
Thanks Shane.  I'll be giving it a try tomorrow.  Regarding a "Yes"
button, there is none to be found on my screen.  If it's in a
different location, please let me know and I'll be happy to comply.

Michael
0
7/8/2009 10:39:01 PM
Reply:

Similar Artilces:

Having problem of Outlook not receiving new e-mails
I have been using Outlook for over 1 year with Comcast Broadband. Suddenly last week, I received a message that Outlook 2000 was experiencing a problem when receiving new e-mails and was going to shut down. I re-opened Outlook and it looked different and then it asked for me set up a profile and I canceled it. But after that window coming up a couple of times after it shut down, I decided to put in a new name and then I could not get to my old e-mails and it acted like a new set up. Then I really got frustrated. I was eventaully able to get back to my old e-mails and have been able t...

warning mail then password Expired
Hi, I was thinking is there a way, that you can get a warning email 5 days before your user password on the domaine expires ?? "Driogan" <Peter@driogan.dk> wrote in message news:98b39d3f-474a-4b05-8f8a-073f030ea57a@r60g2000hsc.googlegroups.com... > Hi, I was thinking is there a way, that you can get a warning email 5 > days before your user password on the domaine expires ?? There's already a warning that can be set when the User logs on....... On 27 Nov., 11:41, "Gordon" <gbpli...@gmail.com.invalid> wrote: > "Driogan" <Pe...@dr...

The Links from e-mails don't work
If I copy the links and insert it into IE 8 it reads it. Trying to link over from an e-mail directly is not working. If I copy the link and go to IE 8.0 the link (URL address) works. It was working before. pgman27 You mean if you click on the link in a message it does nothing, not even an error message? Are you certain IE has all its defaults? Open the Default Programs applet, which you can access either from the Start menu or via the Control Panel, then click the first item: "Set your default programs." After a few seconds, a list of programs comes up. Click on...

linking worksheets #3
I know ho to link cells to oher cells. But is there a convenient way to link ranges or worksheets to others. Hi just link the first cell e.g. ='sheet1'!A1 and copy this formula for your range. The reference will adapt automatically -- Regards Frank Kabel Frankfurt, Germany j van c wrote: > I know ho to link cells to oher cells. But is there a convenient way > to link ranges or worksheets to others. ...

How to sort calendar entries on "size"
I would like to remove large size calendar entries by being able to sort on "size". I am able to sort Inbox items on size but not calendar. My company's exchange server has email account size quota and a 3rd of that quota is being held up by calendar entries on the server side, so I would like to get rid of the unwanted past celndar entries that occupy portion of my account quota. Any help is appreciated. Thanks. Umesh On 11/18/03 9:21 PM, in article 049b01c3ae43$d9cf01d0$a301280a@phx.gbl, "Umesh" <anonymous@discussions.microsoft.com> wrote: > I would...

Insert,Update Data in sage (MS Access Linked tables) using Vb.net form
Hi folks, I am developing application using vb.net which requires integration with SAGE LINE 50 (Accounting software ) V11... The data which SAGE is using is MC ACCESS 2003 database... with linked tables in it... Now I Have developed the Sage connection using ODBC which works fine when reading the record but cannot Add or Update record into the Linked tables.... When i debug the program the error is at the line where it has... <br> MyodbcCommand.ExecutenonQuery() <br> Can anybody Help ????? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/acce...

how to config Server for one user which has 2 mail address.
we have one NT4.0 + Exchange 5.5 Server "A" Email abc@xxx.com.cn ��and another windows2003 + exchange 2003 Server "B" abc@cn.xxx.com user name is same in A B��Mx record was be set ,question is how to config Exchange 2003 to receive down the mail to Server A , because of we need to replace A with B. thanks a lot. E2K3 setup guides you through common scenarios (like yours) pretty much holding your hand - on welcome screen tell it that you have existing E55 org and want to join it, then follow on-screen instructions. Having usable backup of Exchange databases and AD i...

How do I setup an SMTP gateway / smart host for Exchange 5.5 internet bound mail
My current setup has a Windows NT 4.0 Exchange 5.5 server setting on our company LAN behind a Microsoft ISA Server. The Exchange server's Internet Mail Connector binds to (I assume this is the proper terms) port 25 on the ISA server for inbound and outbound Internet Mail. Our company has finally upgraded to a new Cisco Pix Firewall which we are able to setup a DMZ on. The suggestion by our ISP is to setup an SMTP gateway in the DMZ and have our internal Exchange server send mail to it destined for the Internet. I am aware that most of the work for making the connections from the SMTP ...

Link and Embed in 2003
Using the Insert>Picture>From File comand we can use either the 'insert' or 'link to file' command to insert a picture. During our development we prefer to link pictures then when completed save the .ppt with all pictures embedded. 1. When pictures are in slides during design is it possible to tell if the picture is linked or embedded? 2. Is there a way to embed any/all linked pictures when the slide presentation is completed without going to each slide and reinserting the picture as 'insert' Cheers! -- Blumburg In article <07E6153F-5D...

Mail Merge Printing collated
When I print a mail merge (I don't use it for mailings and envelopes), Publisher prints out the first 5 records as an individual document then the next 5 as a seperate document, and so forth. Since I often need to make multiple copies of these documents, I end up having to collate them by hand. How can I get Publisher to print the entire merge as one document before printing the second, third, copy? I believe when I had P'03 it would print that way, but when I upgraded to '07 this problem started. You can't... Maybe later with a service pack these printing bugs will b...

Manual Entry of Puchase Order
We just upgraded to 2.0 and had been running 1.2 for a few years and only upgraded to fix a database problem. Now I have a new one. We put our purchase orders in manualy because it gives us more control of price changes, etc. The new purchase order screens have thrown my entry into a tailspin. Our main vendor has an invoice that is anywhere from 300 - 700 lines and in this new version, manual entry is almost impossible. Any suggestions?????? You can try TOP Import: http://www.retailhero.com/dynamics_rms_order_import.aspx You can either use a data collector to scan items or just simply f...

Video mail VEMAIL.EXE
Just installed VEMAIL.EXE v1.1 and get the message "The fatal error occured" Any tip on how to get this plug in working ? Hi Ant Give up on it - the add-in doesn't work. >-----Original Message----- >Just installed VEMAIL.EXE > v1.1 and get the message "The fatal error occured" >Any tip on how to get this plug in working ? >. > ...

trying to link maps and pie charts
Hello I was trying to link sales data stored in an excel table with a specific country in MapPoint. This software allows you to do this very easily. You can even picture the data in piecharts (% sales for each competitor). However there is very little flexibility with the look of the result: you cannot choose the color of the slices of the pie, you may not display data on the graph, and the maps do not look very professional. I know it is possible to link automatically a table with a shape in visio. Can this shape be a given country/region on a map? Can the callouts have th...

Formatting Linked Cells
I have a project to do. I have to create an input worksheet that is the originator of other worksheets that are linked to the input worksheet. Is there a way to have the linked cells shown as a blank cell if the data (especially text data) is not enter in the input worksheet yet. MT Hi =IF(YourLink="","",YourLink) -- Arvi Laanemets (Don't use my reply address - it's spam-trap) "MT" <MT@discussions.microsoft.com> wrote in message news:5398D6F8-1554-46BB-B009-CCE3183C80ED@microsoft.com... > I have a project to do. I have to create an input ...

make outlook automatically delete html mail with linked images
The junk mail filter should be able to automatically delete html mail with linked images ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/community/en-us/default.mspx?mid=9e1b783b-c9c1-44f2-a1dd-93da59216c56&dg=microsoft.public.outloo...

Retrieve old e-mails
I recently had a hard drive crash on me and had to have the data recovered through a data recovery specialist. All the data on my old drive was recovered and put onto my new hard drive. I did have to install WindowsXP on the new drive. I want to know how to get the e-mails I had in my inbox folder from the files from the old drive so I can respond to them as there were some which had not been read and others which were of importance. Thanks for the help, Brian Brian <anonymous@discussions.microsoft.com> wrote: > I recently had a hard drive crash on me and had to have > the...

Curious Mail Loop (and brain teaser)
I just experienced an enigmatic mail looping issue, anybody have any ideas to keep this from happening again? Here is the Scenario... We have a user whom works for my organization and another government agency, both organizations use Exchange 2000 but there is no interoperability between our systems other than standard SMTP email through the internet, not same AD root, forest or even remotely similar namespace. We are able to induce a loop under the following conditions.: 1. User has an exchange mailbox at both Organization A & Organization B 2. User creates an "Out of the Off...

Link to Page when saving to web
Hi, I have some drawings that have several shapes with "Go to page on double-click" behavior. How can I keep this functionality when saving as a web page? Thanks ...

How to delete incorrect entries from Dictionary
On occasion, Outlook 2000 recommends a spelling that's obviously incorrect. I suppose that I clicked on a word too hastily. I'd like to remove these incorrect entries but how? tools, options, spelling, edit dictionary (from any app that supports the office spell check) - its also available from the spell check screen when you press F7 or you can search for custom.dic and edit it with notepad. -- Diane Poremsky [MVP - Outlook] Author, Teach Yourself Outlook 2003 in 24 Hours Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide) Author, Google and Other Search Engines (Visu...

Unable to send E-Mails #3
I have recently installed broadband and when I attempt to send an E-Mail I get the following message. 554 <E-Mail Adress>: Recipient address rejected: Relay access denied Any help would be gratefully appreciated On Mon, 20 Dec 2004 13:27:03 -0800, LarryM wrote: > I have recently installed broadband and when I attempt to send an E-Mail I > get the following message. > 554 <E-Mail Adress>: Recipient address rejected: Relay access denied > > Any help would be gratefully appreciated You probably need to authenticate to your outgoing server. Set that up on the &...

Mail Relay #7
I have a Exhcahge 2003 FE/BE setup. WE are adding another email server for encryption that will be a n outgoing relay. this will sit between my FE server and my firewall. Do I have to setup another connector to point to this server for all mail? Thanks Rick All outbound internet mail? You can insert the server as a smarthost on SMTP Connector for address space *. -- Bharat Suneja MVP - Exchange www.zenprise.com NEW blog location: www.exchangepedia.com/blog ---------------------------------------------- "Rick" <drummer10980@gmail.com> wrote in message news:1159524368.41...

How to import a list of links into Excel?
Does anyone have any suggestions on how to import a list of links in to Excel? Under the sheet "Date", there is a list of http links under column C, and a list of name under column B, I would like to import each link into specific sheet at cell A1. For example, in sheet "Date", there is a link www.cnn.com in cell C2, and 1 in cell B2, so this link is imported into sheet "1", and keep running the rest of links. Does anyone have any suggestions on how to do it in Excel macro? Thanks in advance for any suggestions Eric Hi Eric If you have numerics in...

Mailing a group of Contacts
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Email Client: pop Is there any way I can select a section of my contacts (A category) eg: friends or Business contacts, and add all their addresses to one email without selecting each one individually? > This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --B_3356593878_1177854 Content-type: text/plain; charset="US-ASCII" Content-transfer-encoding: 7bit On 5/12/10 10:08 PM, in article 59bb8673.-1@webcrossing.JaKIaxP2ac0,...

How to delete stuck file from "All Junk e-mail" Box ?
How to delete stuck file from "All Junk e-mail" Box ? I'm using WLM on Win7. Thanks for any help. "Jdr" <omni@msn.net> wrote in message news:C2919371-6A82-4478-A411-8FEB13F66B41@microsoft.com... > How to delete stuck file from "All Junk e-mail" Box ? > I'm using WLM on Win7. Thanks for any help. try dragging it to the deleted folder. "c.d." <invalid@iglou.com> wrote in message news:es$OnIzzKHA.4384@TK2MSFTNGP06.phx.gbl... > > "Jdr" <omni@msn.net> wrote in message > news:C29193...

using rule creates multiple entries. How can I stop this?
I'm going to give you the details of this so maybe someone can just tell me how to correct or whether it can be corrected. I've tried creating different rules, rules with exceptions, multiple rules with multiple exceptions, all I can think. Here is the scenario. Although I'm using Lisa as an example, this problem applies to every staffer in my 9 person office. Lisa is my secretary. She sends me internal email, staff questions and stuff which goes to a a "Staff" subfolder of the Inbox. I have a rule for this. She also sends me mail she has scanned. I ha...