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?
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
