Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
A macro to delete other macros?
Hello,
I have a macro that makes a copy of the workbook that it's associated with. Is it possible to modify this macro so that the copy of the workbook is devoid of macros? Thank you in advance for your help. Ellen |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
A macro to delete other macros?
Check out Chip Pearson's site:
http://cpearson.com/excel/vbe.htm He shows how to write code that modifies code. But there can be difficulties. If the workbook's project is locked or if the user didn't allow any program access to the project, then you'll have trouble. EllenM wrote: Hello, I have a macro that makes a copy of the workbook that it's associated with. Is it possible to modify this macro so that the copy of the workbook is devoid of macros? Thank you in advance for your help. Ellen -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
A macro to delete other macros?
Thanks so much, Dave. Sounds like a winner!!
"Dave Peterson" wrote: Check out Chip Pearson's site: http://cpearson.com/excel/vbe.htm He shows how to write code that modifies code. But there can be difficulties. If the workbook's project is locked or if the user didn't allow any program access to the project, then you'll have trouble. EllenM wrote: Hello, I have a macro that makes a copy of the workbook that it's associated with. Is it possible to modify this macro so that the copy of the workbook is devoid of macros? Thank you in advance for your help. Ellen -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
A macro to delete other macros?
Hi Dave,
The code on http://cpearson.com/excel/vbe.htm is not working for Excel 2007, Could please help me to get that code working in Excel 2007. Would that be possible. "Dave Peterson" wrote: Check out Chip Pearson's site: http://cpearson.com/excel/vbe.htm He shows how to write code that modifies code. But there can be difficulties. If the workbook's project is locked or if the user didn't allow any program access to the project, then you'll have trouble. EllenM wrote: Hello, I have a macro that makes a copy of the workbook that it's associated with. Is it possible to modify this macro so that the copy of the workbook is devoid of macros? Thank you in advance for your help. Ellen -- Dave Peterson |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
A macro to delete other macros?
The code on http://cpearson.com/excel/vbe.htm is not working for Excel 2007, The VBE object model wasn't changed between 2003 and 2007. The code works in 2007. Can you provide an example of code that works in 2003 but not in 2007? Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group, 1998 - 2009 Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Tue, 25 Aug 2009 10:39:01 -0700, Srinivasulu Vallela <Srinivasulu wrote: Hi Dave, The code on http://cpearson.com/excel/vbe.htm is not working for Excel 2007, Could please help me to get that code working in Excel 2007. Would that be possible. "Dave Peterson" wrote: Check out Chip Pearson's site: http://cpearson.com/excel/vbe.htm He shows how to write code that modifies code. But there can be difficulties. If the workbook's project is locked or if the user didn't allow any program access to the project, then you'll have trouble. EllenM wrote: Hello, I have a macro that makes a copy of the workbook that it's associated with. Is it possible to modify this macro so that the copy of the workbook is devoid of macros? Thank you in advance for your help. Ellen -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Delete Another WorkBook Macros using Macros.. Possible? | Excel Programming | |||
Macro to delete sheets and saves remaining file does not properly delete module | Excel Programming | |||
Macro to delete sheets and saves remaining file does not properly delete module | Excel Programming | |||
Macro to delete sheets and saves remaining file does not properly delete module | Excel Programming | |||
Delete macros in another macro | Excel Programming |