I have the following problem:
I received an Excel file with VBA macro. It runs when pressing the macro button. When I save the file, close it and re-open, it crashes when pressing the macro button. If I then close, re-open and now first save (before running the macro), I can run the macro successfully.
The colleague who wrote the macro, can run it under all circumstances. With other colleagues, for some it works, for others it doesn't.
Does anybody know what could cause this?
I received an Excel file with VBA macro. It runs when pressing the macro button. When I save the file, close it and re-open, it crashes when pressing the macro button. If I then close, re-open and now first save (before running the macro), I can run the macro successfully.
The colleague who wrote the macro, can run it under all circumstances. With other colleagues, for some it works, for others it doesn't.
Does anybody know what could cause this?