Macro to "self-destruct"

[Sharkey79]

Hello,

I've got an Excel-sheet with a macro for my work, but because the Excel-file will be send to a lot of offices when I'm done with it, I want to add a rule in the macro that "self-destructs" the macro... Is this possible?

Best regards,

Chris

[snb]

You can save it as a .csv file.

In E2007 you can save it as an xlsx file.

[Sharkey79]

Hi snb,

Although you're answer might work and you are appreciated for it, it's not what I want...
Is there a way to make the macro delete itself?

Chris

[snb]

Why would you want to avoid the simplest method ?

[Sharkey79]

Because multiple people have to be able to use it without the knowledge of Excel. A key combination everyone can remember without to many questions. Saving it in a different file-extension is another story...

[Domski]

There's info here on deleting all the code in a project: http://www.cpearson.com/excel/vbe.aspx

I'd agree with snb though in that you'd be better off just saving it as a macro free file.

Dom

[snb]

You can even build a macro that performs everything. They don't even have to remember any key combination at all.

Please Login or Register  to view this content.

[Sharkey79]

Hi Domski,

Thanks for the tip and the advice... I'll try the method on the site and see what works best for me (and my colleagues).

Chris

[Sharkey79]

You can even build a macro that performs everything. They don't even have to remember any key combination at all.

Please Login or Register  to view this content.

I was out for lunch and forgot to press submit reply for Domski's post so I didn't see this reply until I submitted the thanks to Domski.

But this looks really good too! Can you explain how this macro works?

Thanks,

Chris

[snb]

Please do not quote.

When the user closes eg. the file "E:\OF\example.xls" it will automatically also be saved as "E:\OF\example.csv".
This file doesn't contain macro's. When a user opens it in Excel it's automatically a workbook and can be used/written into as a normal Excelfile.

There are many more methods depending on what you wish (keep the formatting or only the data, whether the workbook contains 1 or more sheets, etc.)

[royUK]

Using Chip Pearson's code you would not be able to protect the VBA project

[Sharkey79]

@snb

Off topic: What's wrong with "quoting"??
On topic: Okay, that sounds good! Couldn't get the Chip Pearson to work (gives an error) so that would be the best way to go. And you're macro would also help a lot on another problem I've got! Thanks a million snb!

[snb]

Off topic: What's wrong with "quoting"??

Apparently you didn't read the forum rules (nr. 12)

Please Login or Register  to view this content.