![]() |
|
|||||||
| 代码交流 ASP,PHP,JSP等网站源代码下载与交流。 |
|
|
Thread Tools | Display Modes |
|
#1
IP: 218.2.66.178
|
|||
|
|||
|
These two nifty macros enable you to delete the embedded hyperlinks that are generated when typing URLS or copying information from the web.
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 Macros below. Word Hit [ALT]+[F11] to open the Visual Basic Editor Go to "Insert" > "Module" and in the pop-up window copy: Quote:
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" Excel: 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: Quote:
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", this will delete all URLS on the selected worksheet. Last edited by topvip : 2008-05-06 at 03:42 PM |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
|
|