Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to delete part of a macro
Hi,
I have create a macro in a wookbook (DB). this macro opens up another workbook (NF) and copies data from NF. NF itself has macro's within it. when I open NF through the macro in DB I want part of the thisworkbook beforeSave macro in NF to be deleted/replaced is this possible? code in NF is: Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) Application.EnableEvents = False If Range("G5") = "" Or Range("D7") = "" Then Cancel = True MsgBox "Please complete all Mandatory Fields" Else Run €¯saveme€¯ End If Application.EnableEvents = True End Sub It is the Run "saveme" code that I need to be deleted Any idea's? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to delete part of a macro
hi
see this site for info on how to do that.... http://cpearson.com/excel/vbe.aspx regards FSt1 "Arran" wrote: Hi, I have create a macro in a wookbook (DB). this macro opens up another workbook (NF) and copies data from NF. NF itself has macro's within it. when I open NF through the macro in DB I want part of the thisworkbook beforeSave macro in NF to be deleted/replaced is this possible? code in NF is: Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) Application.EnableEvents = False If Range("G5") = "" Or Range("D7") = "" Then Cancel = True MsgBox "Please complete all Mandatory Fields" Else Run €¯saveme€¯ End If Application.EnableEvents = True End Sub It is the Run "saveme" code that I need to be deleted Any idea's? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
help with part of my macro | 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 | |||
ruuning part of a macro from another macro | Excel Programming | |||
macro to delete entire rows when column A is blank ...a quick macro | Excel Programming |