XL.Book.RemoveVBA
-----------------

Removes all VBA scripts (macros) from the workbook.

| Component | Version | macOS | Windows | Linux | Server | iOS SDK |
|---|---|---|---|---|---|---|
| [XL](component_XL.md) | [14.4](newinversion144.md) | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |

MBS( "XL.Book.RemoveVBA"; BookRef ) 

**MBS**( **"XL.Book.RemoveVBA";** /\* Removes all VBA scripts (macros) from the workbook. \*/  
**$BookRef**) /\* The reference to the destination workbook.e.g. $book \*/ 

### Parameters

| Parameter | Description | Example |
|---|---|---|
| BookRef | The reference to the destination workbook. | $book |

### Result

Returns OK or error.

### Description

Removes all VBA scripts (macros) from the workbook.  
It should be called after loading xlsm or xlsb files. Returns true if VBA scripts were found and removed.  
### Release notes

- **Version 14.4**
    - Added [XL.Book.RemovePrinterSettings](https://www.mbsplugins.eu/XLBookRemovePrinterSettings.shtml) and [XL.Book.RemoveVBA](https://www.mbsplugins.eu/XLBookRemoveVBA.shtml) functions.

### Blog Entries

- [New in MBS FileMaker Plugin 14.4](https://www.mbsplugins.de/archive/2024-09-24/New_in_MBS_FileMaker_Plugin_14/monkeybreadsoftware_blog_filemaker)
- [MBS FileMaker Plugin, version 14.4pr6](https://www.mbsplugins.de/archive/2024-09-11/MBS_FileMaker_Plugin_version_1/monkeybreadsoftware_blog_filemaker)

This function checks for a license.

Created 4th September 2024 , last changed 10th September 2024

  
[XL.Book.RemovePrinterSettings](XLBookRemovePrinterSettings.md) - [XL.Book.Save](XLBookSave.md)

[HTML Version](XLBookRemoveVBA.shtml)