| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Delete VBS code via VBA
Greetings,
I am running some macros that copies the current excel file to another based on a certain condition. I would like to also delete the VBA code from the copied file. Can anyone point me to the correct call? Any help is greatly appreciated. (from microsoft.public.excel.programming ) regards. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to Delete VBS code via VBA
Depending on the security setting that each user has chosen (and it's the user's
security setting--not something you can change), you may be able to use Chip Pearson's notes he http://cpearson.com/excel/vbe.htm LetMeDoIt wrote: Greetings, I am running some macros that copies the current excel file to another based on a certain condition. I would like to also delete the VBA code from the copied file. Can anyone point me to the correct call? Any help is greatly appreciated. (from microsoft.public.excel.programming ) regards. -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to Delete VBS code via VBA
thank you. I ended up by rewriting the code.
regards. On Aug 24, 6:12 pm, Dave Peterson wrote: Depending on the security setting that each user has chosen (and it's the user's security setting--not something you can change), you may be able to use Chip Pearson's notes he http://cpearson.com/excel/vbe.htm LetMeDoIt wrote: Greetings, I am running some macros that copies the current excel file to another based on a certain condition. I would like to alsodeletetheVBA codefrom the copied file. Can anyone point me to the correct call? Any help is greatly appreciated. (from microsoft.public.excel.programming ) regards. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Delete code | Excel Discussion (Misc queries) | |||
| Delete Code | Excel Programming | |||
| Code to delete a Line in a another code | Excel Programming | |||
| VBA code delete code but ask for password and unlock VBA protection | Excel Programming | |||
| VBA code to delete VBA code in another Workbook | Excel Programming | |||
Linear Mode
