Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel 2000 should not hyperlink automaticly
Excel 2000 automaticly hyperlinks, and I can't turn it off. I despise this
"feature" more than Clippy himself. I am not a "newbie" and I DON'T want my spreadsheets to do things for me without asking. At the least, it should be something I can turn off. I get stuck manually undoing every hyperlink that is instead a quantity I'm shipping (eg: 10@250). It aggrivates me daily. Thanks! ---------------- 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/comm...ic.excel.setup |
#3
|
|||
|
|||
Sorry Anne,
Neither of those methods are very good paste special, values simply does not work in Excel 2000 maybe you meant copy an empty cell then select area and edit, paste special, add the macro removing hyperlinks one link at a time is inefficient you can delete all links in a selection with one line of code, so would be much faster. i.e. select all cells you might see the difference. Removing object hyperlinks from a Cell or cell range (#DelHyperlinks) http://www.mvps.org/dmcritchie/excel...#DelHyperlinks --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Anne Troy" wrote in message ... Sam, try this: http://www.officearticles.com/excel/...soft_excel.htm ************ Anne Troy www.OfficeArticles.com "Sam Rothstein" <Sam wrote in message ... Excel 2000 automaticly hyperlinks, and I can't turn it off. I despise this "feature" more than Clippy himself. I am not a "newbie" and I DON'T want my spreadsheets to do things for me without asking. At the least, it should be something I can turn off. I get stuck manually undoing every hyperlink that is instead a quantity I'm shipping (eg: 10@250). It aggrivates me daily. Thanks! ---------------- 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/comm...ic.excel.setup |
#4
|
|||
|
|||
Thanks, Dave. Pointed to the wrong kb. I meant this one:
http://www.vbaexpress.com/kb/getarticle.php?kb_id=73 LOL!! ************ Anne Troy www.OfficeArticles.com "David McRitchie" wrote in message ... Sorry Anne, Neither of those methods are very good paste special, values simply does not work in Excel 2000 maybe you meant copy an empty cell then select area and edit, paste special, add the macro removing hyperlinks one link at a time is inefficient you can delete all links in a selection with one line of code, so would be much faster. i.e. select all cells you might see the difference. Removing object hyperlinks from a Cell or cell range (#DelHyperlinks) http://www.mvps.org/dmcritchie/excel...#DelHyperlinks --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Anne Troy" wrote in message ... Sam, try this: http://www.officearticles.com/excel/...soft_excel.htm ************ Anne Troy www.OfficeArticles.com "Sam Rothstein" <Sam wrote in message ... Excel 2000 automaticly hyperlinks, and I can't turn it off. I despise this "feature" more than Clippy himself. I am not a "newbie" and I DON'T want my spreadsheets to do things for me without asking. At the least, it should be something I can turn off. I get stuck manually undoing every hyperlink that is instead a quantity I'm shipping (eg: 10@250). It aggrivates me daily. Thanks! ---------------- 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/comm...ic.excel.setup |
#5
|
|||
|
|||
but on the newer link to delete hyperlinks why would you hard code
the range instead of using a selection. Back to the original question, there is no way to prevent hyperlinks from being created. It is a matter of when you want (or how fast) you can remove them. My suggestion is to just let them be created and then remove the ones you don't want all at once. Microsoft has a MS KB article that purports to tell you how to not create them in Excel 2000 -- it actually lets them be created and removes them with macros and includes an addition to auto_open (or equivalent). You can see that reference on my page -- I don't think it is worth the trouble and there are times that I want a link. Since it was specifically asked for here is the article: http://www.officearticles.com/excel/...soft_excel.htm and it looks to be like it got gutted it used to be KB 233073-- there is no content for the macros. You will find something similar here, and I think it is more straightforward the MS article was anyway. http://www.mcgimpsey.com/macoffice/e...perlinks2.html --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Anne Troy" wrote in message ... Thanks, Dave. Pointed to the wrong kb. I meant this one: http://www.vbaexpress.com/kb/getarticle.php?kb_id=73 LOL!! |
#6
|
|||
|
|||
LOL. NOW look who's putting the wrong link. :)
I'll change my article to link to McG's site; I assume he won't mind. I'll also add another method for those that can't be bothered with delving into macros in 2000. Thanks, Dave. :) ************ Anne Troy www.OfficeArticles.com "David McRitchie" wrote in message ... but on the newer link to delete hyperlinks why would you hard code the range instead of using a selection. Back to the original question, there is no way to prevent hyperlinks from being created. It is a matter of when you want (or how fast) you can remove them. My suggestion is to just let them be created and then remove the ones you don't want all at once. Microsoft has a MS KB article that purports to tell you how to not create them in Excel 2000 -- it actually lets them be created and removes them with macros and includes an addition to auto_open (or equivalent). You can see that reference on my page -- I don't think it is worth the trouble and there are times that I want a link. Since it was specifically asked for here is the article: http://www.officearticles.com/excel/...soft_excel.htm and it looks to be like it got gutted it used to be KB 233073-- there is no content for the macros. You will find something similar here, and I think it is more straightforward the MS article was anyway. http://www.mcgimpsey.com/macoffice/e...perlinks2.html --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Anne Troy" wrote in message ... Thanks, Dave. Pointed to the wrong kb. I meant this one: http://www.vbaexpress.com/kb/getarticle.php?kb_id=73 LOL!! |
#7
Posted to microsoft.public.excel.setup
|
|||
|
|||
Excel 2000 should not hyperlink automaticly
Hi Sam
If you just want (10@250) in a cell, just force it to text by putting a single quote in front of it like this ('10@250). Excel won't display the quote so you will see (10@250) in the cell without the hyperlink. You can use the same trick to type numbers with leading zeros such as postcodes or product numbers in cells. If you type (0186) it will generally display as (186) unless you do some special formatting. But if you type('0186) it will display correctly as (0186). Type ('www.microsoft.com) and it will show the URL without creating the hyperlink. In these examples, the brackets just indicate the cell - don't type them. "Sam Rothstein" wrote: Excel 2000 automaticly hyperlinks, and I can't turn it off. I despise this "feature" more than Clippy himself. I am not a "newbie" and I DON'T want my spreadsheets to do things for me without asking. At the least, it should be something I can turn off. I get stuck manually undoing every hyperlink that is instead a quantity I'm shipping (eg: 10@250). It aggrivates me daily. Thanks! ---------------- 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/comm...ic.excel.setup |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Problems using Excel 2000 to open/save file saved in Excel 2003 | Excel Discussion (Misc queries) | |||
Excel 2003 crashes loading excel files created Excel 2000 | Excel Discussion (Misc queries) | |||
other systems detecting excel 4.0 if excel 2000 is installed | Setting up and Configuration of Excel | |||
Statistical Excel Function Question within Excel 2000... | Excel Worksheet Functions |