View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Neil Neil is offline
external usenet poster
 
Posts: 173
Default vba opens by itself

I have seen similar behaviour when a Workbook contains an AutoExec macro that
has an error - thus it opens the editor so that you can correct the error.

HTH

Neil
www.nwarwick.co.uk


"Winget" wrote:

I have an excel 2003 file which contains relatively simple macros. My problem
is that unprompted by the user excel will open Visual basic while this file
is open. I always have several excel files open at the same time- all with
macros. It only happens with when a certain file is open. I have never seen
this happen in years of working with macros and I cannot find a post related
to the problem.

One thing i did do different with this file is Lock Project for Viewing and
added a password. I have gone back in a removed those choices but it is still
happening.

any ideas out there?