HELP!! Macro suddenly not working

  • Thread starter Thread starter A. Wong
  • Start date Start date
A

A. Wong

Need some help with this one.

I created an Excel application that is currently working on the
company's computers. Many users are able to do what they need to do.
Today I find out that one of the users are having problems opening the
form.

Basically, whenever he opens the workbook (either from e-mail or
desktop), it directly takes him into the Visual Basic Editor. The
strange part is that when I step through the whole project, it works
fine. However, when I open the workbook, the form that gets displayed
does not work correctly... I am unable to tab to other textboxes and
unable to send the information to a database... none of the buttons
work.

I checked the references and none are missing.
I tried another similar Excel application and it does the same thing
(opening straight into the Visual Basic Editor.

Using Excel 2K on Windows XP platform communicating with an Access 97
database.

Any help is greatly appreciated.

Please let me know if there is more information that needs to be
provided.

Thanks in advance.
 
It sounds like there is a problem in the code behind the form, probabl
in accessing a file and because of an untrapped error, the user i
being thrown into the vb editor.

Try running the application on the users machine with some breakpoint
in the form code to find out what is happening
 
If something only works when you step through the code line by line,
it is usually a timimg issue. You are likely to be allowing other
processes to complete before your next line executes. The same thing
can be achieved in code with the DoEvents keyword, which should appear
regularly in your code anyhow. If you need a longer pause in
execution, look at the Sleep Windows API.
 
Back
Top