Using 2003 - Is it possible to prevent cell data entry automatically creating a hyperlink for email/web url's.
Using
Also removes cell formatting etc.
Please Login or Register to view this content.
Prefixing entry with an apostophe is not an ideal option, as it requires all users to be aware of this requirement.
Last edited by wotadude; 06-22-2009 at 09:52 PM.
Hello wotadude,
I don't follow what you are wanting to do. Can you give an example?
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
refer to sample file attached.
Tools > AutoCorrect, Autoformat tab, untick Internet and network paths with hyperlinks.
Entia non sunt multiplicanda sine necessitate
Thanks for that.
I took that approach 1 step further to always disable it for my specific workbook, and enable as required for users preference on other workbooks.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks