Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Programmatically delete macro using a protected project
Can anyone give some help. I have created several projects that
perform similar functions using a .xla file. I have written a macro that deletes all data from one file when I'm ready to start a new job. One of the things I need it to do is delete a macro. I am writing the macro in my add-in, but I want it to delete a macro named "performParse" from the module 'parse' in the active workbook. The active workbook isn't protected, but the code in the add-in is protected. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Programmatically delete macro using a protected project
Try here for pointers:-
Programming To The Visual Basic Editor http://www.cpearson.com/excel/vbe.htm -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "John Cole, Jr." wrote in message om... Can anyone give some help. I have created several projects that perform similar functions using a .xla file. I have written a macro that deletes all data from one file when I'm ready to start a new job. One of the things I need it to do is delete a macro. I am writing the macro in my add-in, but I want it to delete a macro named "performParse" from the module 'parse' in the active workbook. The active workbook isn't protected, but the code in the add-in is protected. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.789 / Virus Database: 534 - Release Date: 07/11/2004 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Assigning the Help 4, *.HLP file for a project programmatically in a protected Project | Excel Programming | |||
How to programmatically check if a workbook is protected t? | Excel Programming | |||
delete row programmatically | Excel Programming | |||
Accesing vba project from wb that has vba project password protected | Excel Programming | |||
VBA - Programmatically Change VBA Project Password | Excel Programming |