In the spreadsheet * Press Alt-F11 to open the VB macro editor * Select the required sheet * Enter the following macro code Sub ZapHyperlinks() Cells.Hyperlinks.Delete End Sub * Run the code - Green triangle or Menu->Run->Run Macro or F5 (possibly) * This should remove all hyperlinks in the entire sheet |
Monday 2 August 2010
Excel : Remove all hyperlinks
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment