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

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

/On Mon, 21 Mar 2005 18:15:04 -0800, "kalz"
wrote:

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

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



"kalz" wrote in message
...
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

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




"Gary Brown" wrote in message
...
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



"kalz" wrote in message
...
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