Macro to remove all macros

[ad9051]

Hello all, as always thank you for taking the time to look at my problem. Sounds a crazy thing to want to do, but my aim is to supply these spreadsheets as data to collegues. I would like to provide them a macro free version, im not sure if it is possible to have a
'suicidal' macro, deleting all macros including its self?

Strange request but this is what i need.

All the best

Alan

[Whizbang]

I haven't tested it, but a quick Google search gave me this.

http://www.exceltip.com/show_tip/Mod...Excel/505.html

I assume that you would actually house the procedure in your "Personal" workbook and run it from there. This way there is no "deleting itself" paradox.

[Leith Ross]

hello ad9051,

Here is a better version. This does not require adding a reference to the workbook and will automatically unlock your VBA Project, if you have it locked, by supplying the password.

This code removes all macros in the workbook that this macro runs in. The macro deletes itself as well.

Remove All Macros and Unlock VBA Project

Please Login or Register  to view this content.

[nimrod]

If you save your file as a "xlsx" file the macros will automatically be removed... could'nt you just save the distibution copy as the "xlsx" version ?