Macros

Hi Jessica,

Hopefully, the following steps will help:

Open the workbook that contains the macro that you want to delete.
If the macro that you want to delete is stored in the personal macro workbook (Personal.xlsb), and this workbook is hidden, do the following to unhide the workbook:

On the View tab, in the Window group, click Unhide.
Under Unhide workbooks, click PERSONAL, and then click OK.

You can then delete that workbook.

If this doesn't help, try the following:

In Excel, press Alt+F11 to activate the Visual Basic Editor.

In the Project Explorer on the left hand side, you'll see (among others) VBAProject (PERSONAL.XLSB).

Expand this until you see the individual modules under Modules.

If you want to remove ALL modules, right-click each module in turn and select Remove <modulename> from the context menu.

If you want to remove one or more specific macros, double-click each module in turn and look at the code. You can remove a macro by deleting its code (from Sub ... up to and including the corresponding End Sub).

When you're done, close the Visual Basic Editor. Don't forget to save the personal macro workbook when prompted.

I hope this helps.

Kind regards
Marius