| << | The Future of Music? | Welcome! | >> |
Remove All Hyperlinks in Excel and Word
| posted at 15:16:32 By Flipping Heck! | Posted In Software Tips |
Ever copy and paste something from the Internet and then into Word only to get the hyperlinks embedded? You can removed them easily with the Macro below.
Hit [ALT]+[F11] to open the Visual Basic Editor
Go to "Insert" > "Module" and in the pop-up window copy:
Sub RemoveHyperlinks()
Dim oField As Field
For Each oField In ActiveDocument.Fields
If oField.Type = wdFieldHyperlink Then
oField.Unlink
End If
Next
Set oField = Nothing
End Sub
Then click "File" > Close and return to Microsoft Word
You can now run the Macro in Word by going to:
Tools > Macro > Macro and then Run "RemoveAllHyperlinks"
You can do the same in an Excel Document:
Hit [ALT]+[F11] to open the Visual Basic Editor
Go to "Insert" > "Module" and in the pop-up window copy:
Sub RemoveHyperlinks()
'Remove all hyperlinks from the active sheet
ActiveSheet.Hyperlinks.Delete
End Sub
Then click "File" > Close and return to Microsoft Excel
You can now run the Macro in Excel by going to:
Tools > Macro > Macro and then Run "RemoveAllHyperlinks"
| Click To View Comments (8) | Trackback URL | |
| << | The Future of Music? | Welcome! | >> |
Archive
Categories
Blogging Business Coding Design Email From My Mobile Google GTD/Productivity Humour Life Hacks Motivation Movie Reviews News Personal Project Management Psychology/Body Language Quizzes/Tests Rants Review Site News Software Tips TechnicalRecent Posts
Threat of redundancy forcing us into unpaid overtime How to run an appraisal Stephen Covey launches a new Community Site Multitasking revisited: How much time are we wasting? How to run Productive Meetings - Guest post at Simpleology.com "Productive" Magazine Launched Shock Horror! Obama may lose Blackberry priviledges!Recent Comments
It seems that the URI at the link that says "checking the new community site out." is wrong. Instead....
“Multitasking” is a concept created within the realm of systems engineering. Simply put, it is a way....
If you are organizing meetings you can use online meeting minutes tool at http://minutesofmeeting.n....
If you are organizing meetings you can use online meeting minutes tool at http://minutesofmeeting.n....
After five hours of work your productivity decreases by as much as 50%; long hours at work are usele....
Here's Microsoft's guide to changing macro settings in Office 2007: http://office.microsoft.com/en-u....
Umm.... only one problem.... microsoft word 2007 and excel 2007, do NOT have a "Tools" > option !....
Last link did not work right. Here it is: http://outofeggs.com ....
You might also want to try out You" target="_blank">http://outofeggs.comYou can customize it ho....
On the lists deodorant is spelled incorrectly - you spelled it "deoderant"....
Stats
since February 2004
9 Reading Now
View the Tag Cloud or View the Category Cloud
Subscribe
RSS Feed
Subscribe to the RSS Feed by clicking on the icon below and add the URL to your feed reader
Featured Posts
GTD - Back to basics 6 - The round-up Managing Projects in one Place Managing Web Projects - The Whole Shebang Managing your time and procrastination levels with the ktDPlan ktGTD - Projects/Actions with a Moleskine Mindmapping Resources Manage Your Manager - How to cope with Ineffectual leadership Writing good meeting minutes revisited Getting Things Done with Thunderbird Get people re-involved: Change the format Project and Next Action Organisation Time Management: Procrastination vs GTD and Non-Conditional Scheduling Organising your desktop Recover "permanently" deleted items in Outlook Grocery Shopping Hack: Weekly Shopping Lists Using Flags and Rules In Outlook 2003 for GTD Make your blog search engine friendly My Life Organised and Outlook [argh!] How to market your blog and keep your readers GTD with a Pocket PC Improving Outlook with a custom dashboard Organising your Digital Photos Managing Tasks in Outlook Organising and Managing your DVD collection What is GTD?Popular Posts
How to write good meeting minutes Getting Things Done with Thunderbird Writing good meeting minutes revisited Grocery Shopping Hack: Weekly Shopping Lists Organising your desktop GTD - Back to basics 6 - The round-up Improving Outlook with a custom dashboard 7 Habits: Habit 4 - Think Win/Win Using Flags and Rules In Outlook 2003 for GTD Four Hour Work Week in the Real World? Dream onBlog Roll
A Bloke Near Where I live Cranky Middle Manager Show Dilbert Focused Performance GTD Wannabe My Boyfriend is a Twat Project Management Institute - eBusiness Specific Interest Group Random Acts Of Reality RoundACow Smidsy The Mad Admin The Register Wide Awake Wesley Wil Wheaton In Exile Suggest a siteAdmin
To log in, enter your usernameand password below:
This website and all its contents are © Katy Whitton 2010
