Components | All | New | MacOS | Windows | Linux | iOS | ||||
Examples | Mac & Win | Server | Client | Guides | Statistic | FMM | Blog | Deprecated | Old |
XL.Book.RemoveVBA
Removes all VBA scripts (macros) from the workbook.
Component | Version | macOS | Windows | Linux | Server | iOS SDK |
XL | 14.4 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |
MBS( "XL.Book.RemoveVBA"; bookRef ) More
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 and XL.Book.RemoveVBA functions.
Blog Entries
This function checks for a license.
Created 4th September 2024, last changed 10th September 2024