View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Jurassien Jurassien is offline
external usenet poster
 
Posts: 24
Default How to remove macro saved on excel folder

Hi,
It seems like there is no way to delete any VBA project file (i.e. aaa.xls)
once it is created. I have already got rid of the module, but I still have
this project file listed and anytime I start excel, "Microsoft Excel - aaa
pops up.

Thanks,

"Gord Dibben" wrote:

Expand aaa.xls by clicking on the "+" sign.

Double-click on a module and EditFind for a reference to Personal.xls

Delete that reference.


Gord Dibben MS Excel MVP

On Tue, 20 Feb 2007 09:19:20 -0800, Jurassien
wrote:

I am still having trouble removing the macro in question. Is there any
option that can help remove this macro from the VBA project File? because I
can see the project file Name ( aaa.xls) and I want to delete it, but I can't.

Thanks,

"Earl Kiosterud" wrote:

Jurassien,

If the macro is in the Personal.xls workbook you'll have to unhide it first. Window -
Unhide. Now use Tools - Macro - Macros, and go from there.
--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"Jurassien" wrote in message
...
Hello,
How do I remove macro under the following path: Personal.xls then the macro
name?

Thanks,