excel executes only a part of a macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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 said:
I wrote a macro that reads data from cells, make some algebraic
Click to expand...
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,

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 said:
I wrote a macro that reads data from cells, make some algebraic
Click to expand...
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?
 
Back
Top