From the Edit Hyperlink dialog box, click on the Remove Hyperlink button and. You may want to export the VBA code, using the procedure above, before deleting the VBA code. Lesson Summary A Hyperlink is a link that points to a file, a specific.

Standard modules, user forms, and class modules will be removed, and code within the ThisWorkbook module and the sheet modules will be deleted. You should use this procedure with care, as it will permanently delete the code.

The procedure below will delete all the VBA code in a project. Try going to: Office button -> Excel Options -> Trust Center -> Trust Center Settings -> External Content -> select either Prompt or Disable in. When you open the definition information management. NOTE THE WARNING in there as it will permanently delete the code. In Excel 2007, Trust Center>Macro Settings>Disable all macros with notification is selected by default.

Have you deleted the modules as well, as any module whtheer empty or not will trigger the message.įailing that, the following is from Chip Pearson's website, and will delete all VBA in a projects.

Disable links in excel 2003 spreadsheet