Run Time Error 1004

T

Trisha

I have a user that is using an Excel Application. This
application does have programming behind it, but nothing
too difficult, mainly automatic saves and bringing up
other worksheets when a button is clicked. One user that
is off-site gets a run-time error 1004 when clicking some
of the buttons. I have tested on a computer that was
built exactly like his and do not receive that error.
Would a downloaded screensaver, wallpaper, games, anything
cause this to happen? I don't understand why I'm not
getting the error, but he is.

Thanks in advance,
Trisha
 
D

Dave Peterson

How do they run the macro?

If you run it from a control on the worksheet from the controltoolbox toolbar,
then try changing the control's .takefocusonclick property to false.

If that control doesn't have a .takefocusonclick property, then add this to the
top of your code:
activecell.activate

This a bug in xl97 that was fixed in xl2k.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top