Tuesday, October 25, 2011

How to Delete Links in Excel 2003


1. Launch Microsoft Excel 2003. Click on 'File' and select 'Open.' Locate the Excel file on your computer that contains links you want to remove. Double-click the file to open it in Excel.
2. Press the 'Alt' key and 'F11' key on your keyboard simultaneously. The visual basic editor will appear.
3. Click on 'Insert' and select 'Module.' A new window will appear, allowing you to input visual basic coding.
4. Copy and paste the following code into the editor:Sub RemoveHyperlinks()'Remove all hyperlinks from the active sheetActiveSheet.Hyperlinks.DeleteEnd Sub
5. Click on 'File' and select 'Close and Return to Microsoft Excel.' The visual basic editor will close.
6. Click on 'Tools' in Microsoft Excel and hover over 'Macro.' Scroll over and click on 'Macros.' A dialog box will appear listing all saved Macros for Excel 2003.
7. Select 'RemoveHyperlinks' from the list of macros and click 'Run.' Excel will run the macro and automatically delete all hyperlinks from the spreadsheet.

Blogger news