saving files with macros

arab

New Member
Joined
Aug 25, 2002
Messages
11
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
 

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.
See if this helps:

Application.Workbooks("MyWork").VBProject.vbcomponents.Remove _
Application.VBE.ActiveVBProject.vbcomponents("Module1")
 
Upvote 0

Forum statistics

Threads
1,218,830
Messages
6,144,724
Members
450,567
Latest member
Mplz

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top