woensdag 6 mei 2009

Hyperlinks vewijderen in Excel

Select the cells with the hyperlinks that you want to remove.
Start Visual Basic Editor (Alt+F11).
Open sub window "Direct" (Ctrl+G).
Type: selection.hyperlinks.delete
and click on Enter key.

Attention: CTRL+Z doesn't restore the hyperlinks.

Geen opmerkingen: