excel executes only a part of a macro
 

I wrote a macro that reads data from cells, make some algebraic calculations and makes two graphs and creates a new sheet with reported values.It works fine, but sent to other users it makes only one graph without contionuos lines, it does not show a text box with some calculated values on the graph area. It does not make the second graph and does not add a new sheet with a report. No error message is shown.The code of the macro is transmited correctly so that the same code on different PCs (same windows, all excel 2000) does not produce same result.Does anybody know what is going on?
mgr

excel executes only a part of a macro
 

Have you tried transferring the whole workbook with code and data, not just
the VBA code?

Is this problem true on all PCs other than your own?

If it still is a problem I suspect that the environment and sheets are not
the same in the target environment. If your macro relies on this then you
should establish this as part of the programme.

Finally it is difficult to assess the code if you do not post it.

Cheers
N

"mgr" wrote in message
...
I wrote a macro that reads data from cells, make some algebraic
calculations and makes two graphs and creates a new sheet with reported
values.It works fine, but sent to other users it makes only one graph
without contionuos lines, it does not show a text box with some calculated
values on the graph area. It does not make the second graph and does not add
a new sheet with a report. No error message is shown.The code of the macro
is transmited correctly so that the same code on different PCs (same
windows, all excel 2000) does not produce same result.Does anybody know what
is going on?
mgr




----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =---

excel executes only a part of a macro
 

Mgr,

Sounds like it's got an error somewhere which doesn't show as an error
dialog but simply quits.

You could try stepping through the code using the debugger on their computer
to locate the fault.

Rob


"mgr" wrote in message
...
I wrote a macro that reads data from cells, make some algebraic
calculations and makes two graphs and creates a new sheet with reported
values.It works fine, but sent to other users it makes only one graph
without contionuos lines, it does not show a text box with some calculated
values on the graph area. It does not make the second graph and does not add
a new sheet with a report. No error message is shown.The code of the macro
is transmited correctly so that the same code on different PCs (same
windows, all excel 2000) does not produce same result.Does anybody know what
is going on?
mgr