| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
remove hyperlinks in a worksheet all in the same time
Dear all,
I have got some hyperlinks in my excel worksheet which may be removed and replaced by characters one by one. HOw can these hyperlinks be removed all in the same time? Thanks you |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
remove hyperlinks in a worksheet all in the same time
Try this little macro:
Sub HyperBeGone() For Each r In ActiveSheet.UsedRange If r.Hyperlinks.Count 0 Then r.Clear End If Next End Sub -- Gary''s Student - gsnu2007f "Kent" wrote: Dear all, I have got some hyperlinks in my excel worksheet which may be removed and replaced by characters one by one. HOw can these hyperlinks be removed all in the same time? Thanks you |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
remove hyperlinks in a worksheet all in the same time
Thank you Gary, what I need is only to remove the hyperlink, but not delete
the content. Any new idea please? Kent "Gary''s Student" ... Try this little macro: Sub HyperBeGone() For Each r In ActiveSheet.UsedRange If r.Hyperlinks.Count 0 Then r.Clear End If Next End Sub -- Gary''s Student - gsnu2007f "Kent" wrote: Dear all, I have got some hyperlinks in my excel worksheet which may be removed and replaced by characters one by one. HOw can these hyperlinks be removed all in the same time? Thanks you |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
remove hyperlinks in a worksheet all in the same time
select your range to clean
alt-f11 (to see the VBE) ctrl-g (to see the immediate window) type this and hit enter selection.hyperlinks.delete And then close this window and go back to excel. Kent wrote: Dear all, I have got some hyperlinks in my excel worksheet which may be removed and replaced by characters one by one. HOw can these hyperlinks be removed all in the same time? Thanks you -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
remove hyperlinks in a worksheet all in the same time
I don't think I'd use r.clear.
That'll clean up way more than just the hyperlink. Gary''s Student wrote: Try this little macro: Sub HyperBeGone() For Each r In ActiveSheet.UsedRange If r.Hyperlinks.Count 0 Then r.Clear End If Next End Sub -- Gary''s Student - gsnu2007f "Kent" wrote: Dear all, I have got some hyperlinks in my excel worksheet which may be removed and replaced by characters one by one. HOw can these hyperlinks be removed all in the same time? Thanks you -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
remove hyperlinks in a worksheet all in the same time
Dear Dave,
I can't follow your instruction starting from "ctrl-g (to see the immediate window)" and where should I type "selection.hyperlinks.delete"? "Dave Peterson" ... select your range to clean alt-f11 (to see the VBE) ctrl-g (to see the immediate window) type this and hit enter selection.hyperlinks.delete And then close this window and go back to excel. Kent wrote: Dear all, I have got some hyperlinks in my excel worksheet which may be removed and replaced by characters one by one. HOw can these hyperlinks be removed all in the same time? Thanks you -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
remove hyperlinks in a worksheet all in the same time
Use alt-f11 to open the VBE.
Hit control-g to see the immediate window (Or use View|Immediate Window) type or paste that "selection.hyperlinks.delete" into that immediate window. Kent wrote: Dear Dave, I can't follow your instruction starting from "ctrl-g (to see the immediate window)" and where should I type "selection.hyperlinks.delete"? "Dave Peterson" ... select your range to clean alt-f11 (to see the VBE) ctrl-g (to see the immediate window) type this and hit enter selection.hyperlinks.delete And then close this window and go back to excel. Kent wrote: Dear all, I have got some hyperlinks in my excel worksheet which may be removed and replaced by characters one by one. HOw can these hyperlinks be removed all in the same time? Thanks you -- Dave Peterson -- Dave Peterson |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
remove hyperlinks in a worksheet all in the same time
Thank you Dave, I've done it.
"Dave Peterson" ... Use alt-f11 to open the VBE. Hit control-g to see the immediate window (Or use View|Immediate Window) type or paste that "selection.hyperlinks.delete" into that immediate window. Kent wrote: Dear Dave, I can't follow your instruction starting from "ctrl-g (to see the immediate window)" and where should I type "selection.hyperlinks.delete"? "Dave Peterson" ... select your range to clean alt-f11 (to see the VBE) ctrl-g (to see the immediate window) type this and hit enter selection.hyperlinks.delete And then close this window and go back to excel. Kent wrote: Dear all, I have got some hyperlinks in my excel worksheet which may be removed and replaced by characters one by one. HOw can these hyperlinks be removed all in the same time? Thanks you -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I remove many hyperlinks from a spreadsheet at one time? | Excel Discussion (Misc queries) | |||
| Remove Hyperlinks from multiple cells at the same time | Excel Discussion (Misc queries) | |||
| How do I remove ALL hyperlinks from a large worksheet? | Excel Discussion (Misc queries) | |||
| How to remove all hyperlinks from a worksheet in Excel? | Excel Worksheet Functions | |||
| remove all Hyperlinks at one time. | Excel Discussion (Misc queries) | |||
Linear Mode
