Workbook BeforeSave Party
This event will run in advance of a workbook will save.
SaveAsUI – The SaveAsUI parameter will decide if the Help you save As Dialog will exhibit. To display screen the Help you save As Dialog established the SaveAsUI benefit to Genuine. If you do not want the Help save As Dialog to display set the SaveAsUI price to Bogus.
Terminate – The terminate parameter is first established to Wrong when the function begins. If the terminate parameter is set to price of Correct then the workbook will not conserve.
Workbook BeforeXmlExport Party
This function will run right before Excel will save or exports XML knowledge from this unique workbook.
Map – The map parameter returns the map that is remaining saved or exported as an XMLMap object. This parameter can be used to manipulate the XML map object and its attributes.
URL – The URL parameter returns area of wherever the XML map will be saved as a string.
Terminate – The cancel parameter is authentic set to Phony when the party begins. If the cancel parameter is set to value of Accurate then the workbook will not conserve or export the XML map.
Workbook BeforeXmlImport Occasion
This celebration will operate just before Excel imports XML knowledge into or refreshes XML info within this specific workbook.
Map – The map parameter returns the map that is getting imported or refreshed as an XMLMap item. This parameter can be made use of to manipulate the XML map object and its qualities.
URL – The URL parameter returns deal with route of the XML map is saved as a string. Assigning a benefit to this parameter will inform Excel that exactly where the XML file that has XML data is positioned.
IsRefresh – The isRefresh parameter will return a value of Real if the XML map is becoming refreshed and a value of Fake if the XML map is becoming imported.
Terminate – The cancel parameter is primary established to Phony when the party begins. If the cancel parameter is established to benefit of Real then the workbook will not import or refresh the XML map.
Workbook Deactivate Celebration
This event will operate just about every time a person selects a distinct workbook.
Workbook NewChart Function
This event will operate every single time a new chart is established in the distinct workbook.
Ch – The ch parameter returns the newly designed chart as an chart item to allow buyers to manipulate the events, procedures and qualities.
Workbook NewSheet Occasion
This celebration will run each time a new workbook is produced in the particular workbook.
Sh – The sh parameter returns the freshly established worksheet as a worksheet object to allow for customers to manipulate the situations, procedures and qualities.