<div>
Presumably the Library is just where the documents are being stored??<br />
<br />
To view or edit the file it would still have to be downloaded onto the User's machine and opened using the local installation of Excel. Assuming the local installation is compatible with the code in the downloaded workbook there is no reason why it would not work.<br />
<br />
Compatibility issues could include:<br />
- version of Excel, 2010, 2013 etc<br />
- 32 or 64 bit<br />
- macro security settings<br />
<br />
Thanks<br />
Rob H<br />
<br />
PS A UDF is still VBA but triggered by a formula rather than an event or command.
</div>


Presumably the Library is just where the documents are being stored??

To view or edit the file it would still have to be downloaded onto the User's machine and opened using the local installation of Excel. Assuming the local installation is compatible with the code in the downloaded workbook there is no reason why it would not work.

Compatibility issues could include:
- version of Excel, 2010, 2013 etc
- 32 or 64 bit
- macro security settings

Thanks
Rob H

PS A UDF is still VBA but triggered by a formula rather than an event or command.

<div>
Thanks, Rob. &nbsp;So if the spreadsheet is rendered in the browser, the vba will not work ?
</div>


Thanks, Rob.  So if the spreadsheet is rendered in the browser, the vba will not work ?

<div>
<div class="content wysiwyg-content">
If an Excel spreadsheet with some VBA code is loaded into a SharePoint library, will the vba code still work ? &nbsp;Or do I have to convert the code to UDF ? &nbsp;Thanks.
</div>
</div>


If an Excel spreadsheet with some VBA code is loaded into a SharePoint library, will the vba code still work ?  Or do I have to convert the code to UDF ?  Thanks.

VBA in SharePoint

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Sharepoint is a software platform and family of software products used for collaboration and web publishing combined. These capabilities include developing web sites, portals, intranets, content management systems, search engines, wikis, blogs, and other tools for business intelligence and collaboration. SharePoint has a Microsoft Office-like interface, and it is closely integrated with the Office suite.