Deletion of macro through a macro in Excel | Excel forum

Resolved · Urgent Priority · Version 2003

Tue 3 Nov 2009, 12:59 Delegate Rahela said...

Rahela has attended:
Excel VBA Intro Intermediate course

Deletion of macro through a macro in Excel

Hello,

How do we delete/remove a macro which already exist in the output file(it is nothing but just the formatting of input file and placing in some other folder, thus the input file contains some macro which needs to be deleted while showing it as output file) generated through a macro written in other excel file?

Tue 3 Nov 2009, 16:37 Trainer Anthony said...

RE: Deletion of macro through a macro in Excel

Hi Rahela, thanks for your query. First of all, here are a couple of links which contain code to answer your question:

http://excel.tips.net/Pages/T003073_Deleting_Macros_from_within_a_Macro.html

http://www.pcreview.co.uk/forums/thread-1005665.php

However, I think we talked about this and if I remember correctly, you wanted to create some code to generate workbooks containing specific worksheets from a master workbook. Have you created a macro to do this and, if so, do you child workbooks contain macros? Hence your query? If you create code to copy out worksheets into a new workbook, those new child workbooks shouldn't contain any macros in them, so I'm intrigued about the code you need to delete. I hope the above links help, but if you need further assistance just let me know.

Hope this helps,

Anthony