How to remove macro from Personal Workbook

[mollywage]

Hi, I use Excel 2003. I have saved a macro in my personal workbook that did not work. Now, I suspect it is causing a problem when I try to download file into CSV format. How do I remove the macro from my personal workbook? I went into Visual Basic Editor to remove the module in the PERSONAL.XLS. The module came back after I rebooted.

 

[jkpieterse]

Excel should have prompted you whether or not to save changes to your personal macro workbook. Did you select Yes?

 

[mollywage]

Yes, it was saved in my Personal Workbook, but I can not locate it to remove the Macro.

 

[mollywage]

Does anyone have any suggestions to my question? Thanks.

 

[Jeff Meyers]

Follow these instructions (post #2):

http://www.excelforum.com/excel-general/589421-delete-macro-from-personal-xls-cannot-find.html

And from Microsoft Office Help / Support (scroll to the bottom on this one):

http://office.microsoft.com/en-us/help/create-or-delete-a-macro-HP010014111.aspx