delete personal macro

K

kalz

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
 
G

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
 
Top