If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Hyperlink Removal
Deactivate several hyperlinks at once:
Type the number 1 in a blank cell, and right-click the cell. Click Copy on the shortcut menu. While pressing CTRL, select each hyperlink you want to deactivate. (To select a cell that has a hyperlink in it without jumping to the hyperlink destination, click the cell and hold the mouse button until the cursor becomes a cross , then release the mouse button.) Click Paste Special on the Edit menu. Under Operation, click Multiply and then click OK. "Andy Brown" wrote in message ... Or this CTRL-A ; copy ; paste ; ESC. Rgds, Andy |
#2
|
|||
|
|||
Hyperlink Removal
I didn't see the original post but if you want to remove all the links on a
sheet..... Sub SeeYaLinks() ActiveSheet.Hyperlinks.Delete End Sub ...or you can tweak for only selected cells or however you like. Dennis ========== In article , (Doug) wrote: Deactivate several hyperlinks at once: Type the number 1 in a blank cell, and right-click the cell. Click Copy on the shortcut menu. While pressing CTRL, select each hyperlink you want to deactivate. (To select a cell that has a hyperlink in it without jumping to the hyperlink destination, click the cell and hold the mouse button until the cursor becomes a cross , then release the mouse button.) Click Paste Special on the Edit menu. Under Operation, click Multiply and then click OK. "Andy Brown" wrote in message ... Or this CTRL-A ; copy ; paste ; ESC. Rgds, Andy |
Thread Tools | |
Display Modes | |
|
|