hello all
bit of a problem
i've got a macro that imports data from an external file and then creates a chart with this data. It then prompts the user to save the file by a different name. What i need is a way to disable the macro on this saved file so that i doesn't run the next time the user opens the saved file (because it causes a runtime error due to some data already being present in the selected cells).
not sure if i'm being all that clear but some help would be cool
cheers
arab in the excel desert
bit of a problem
i've got a macro that imports data from an external file and then creates a chart with this data. It then prompts the user to save the file by a different name. What i need is a way to disable the macro on this saved file so that i doesn't run the next time the user opens the saved file (because it causes a runtime error due to some data already being present in the selected cells).
not sure if i'm being all that clear but some help would be cool
cheers
arab in the excel desert