View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
ramunlim ramunlim is offline
external usenet poster
 
Posts: 4
Default How do I remove VBA projects in Excel

Each is an excel file - one is personal.xls and the other is book1.xls
However, they come up with each new excel file I create and cannot be
eliminated from the old files. I delete them and they re-appear every time I
open the original excel files.


"Dave Peterson" wrote:

What are the names of these files/projects?

Maybe they're not associated with any file--maybe they're associated with excel.

ramunlim wrote:

Previous information is:

My excel in 2003 version had two unwanted files piggybacked on each new excel
file I made. I thought that ths would be cured by installing 2007 but still
they are there and on each new file I create. How do I get rid of them.

"Luke M" wrote:

Do you have macros enabled? It sound like you might have something encoded in
the VBA for your personal.xls

The personal.xls sheet is what Excel uses to store your personal settings.
If you have a macro written to it, any workbook you open will have these
settings applied. You can open the VBA editor by pressing Alt+F11 to check.
--
Best Regards,

Luke M


Luke -

It appears that you are right (I can see them as VBA projects when I
AltF11) but for the life of me, I cannot find a way to delete these projects
- can you help?

Dick Myers


--

Dave Peterson