delete personal macro

[Guest]

Hi,
I've created a macro in my personal wkbk,however, I dont know how to delete
the macro completely. I tried to delete from tool --> macro.... , a pop up
says I hav to unhide a wkbk to perform. For this, I dont really understand
which workbk its asking actually? The orginal one when I was creating the
marco?

thx

 

[Myrna Larson]

The workbook to unhide is Personal.xls. You do that from the Window menu.

 

[Gary Brown]

TOOLS / MACRO/ VISUAL BASIC EDITOR
In the Project Window (upper left window), you will see "Personal.xls".
Under 'Personal.xls' you will see 'Microsoft Excel Objects' and 'Modules'.
Under 'Modules', you will see the macro you created.
Assuming it is called 'Module1'...
Under 'Modules', you will see 'Module1'.
Right click on 'Module1' and a menu will appear.
Left click on 'Module1'.
Follow the prompt to delete the module.
Done.
HTH,
Gary Brown

 

[Gary Brown]

Left click on 'Remove Module1...'.
Follow the prompt to delete the module.