VBA micros

Question

I have Workbooks using VBA micros and 365 says it can’t run, is there anything I can do?

Answer 1

I'm not sure about the compatibility of the 10th Generation iPad with VBA macros. However, you can try the solutions I provided earlier to see if they work. If you have any other questions, please let me know.

Reference (1) vba - How do I run Excel Macros on an iPad? - Stack Overflow. https://stackoverflow.com/questions/68293582/how-do-i-run-excel-macros-on-an-ipad. (2) Excel for iPad Help - Microsoft Support. https://support.microsoft.com/en-us/office/excel-for-ipad-help-6b5dc2e1-a8e4-48e6-bb69-cb9a3964bc91. (3) Excel macros on iPad - Microsoft Community. https://answers.microsoft.com/en-us/msoffice/forum/all/excel-macros-on-ipad/3d4be409-5f89-453b-8ec3-a7e968a0b4d3.

Answer 2

Should this work on 10th Generation iPad.

Answer 3

I'm Ajibola, an Independent Consultant here and a Microsoft user like you. I don't work for Microsoft.

If you have workbooks that use VBA macros, and you encounter issues with them when using Microsoft 365, there are a few potential reasons for this and some actions you can take:

Macro Security Settings: Microsoft 365 includes security features that may prevent VBA macros from running if the macro security settings are set to high or if macros are disabled by default. To enable macros, you can adjust the macro security settings in Excel:

Go to "File" > "Options" > "Trust Center" > "Trust Center Settings." Select "Macro Settings" and choose the desired security level. You may choose to enable all macros or select "Enable all macros (not recommended; potentially dangerous code can run)" for testing purposes. Be cautious when enabling macros from unknown or untrusted sources. Digital Signature: If your VBA macros are digitally signed, they are more likely to run without issues. Digitally signing your macros adds an extra layer of security and helps avoid potential security warnings.

Enable All Macros for Specific Workbooks: If you have specific workbooks with trusted macros that you want to run, you can add them to the Trusted Locations in Excel. This way, Excel will automatically trust macros in those workbooks:

Go to "File" > "Options" > "Trust Center" > "Trust Center Settings." Select "Trusted Locations" and add the folder containing the workbooks or individual workbooks you want to trust. Compatibility Mode: If your workbooks were created in older versions of Excel, they may be in compatibility mode in Microsoft 365. While in compatibility mode, some features, including macros, may not work correctly. To ensure compatibility, you can try saving the workbook in the latest Excel format.

Update Office and VBA Libraries: Make sure you have the latest version of Microsoft Office installed, including all updates. Outdated software versions may have compatibility issues with VBA macros.

Check for Conflicts: Ensure that there are no conflicts with other add-ins, extensions, or settings in Microsoft 365 that might be affecting the execution of VBA macros.

Error Handling: Add error handling code to your VBA macros to catch and handle any unexpected errors or issues that may arise during execution.

Debug and Test: Review your VBA code and run it in the VBA editor to check for any errors or issues. Use the VBA editor's debugging tools to identify and fix potential problems.

If you've tried the above steps and still encounter issues with your VBA macros in Microsoft 365, it's possible that the macros may have code that is not compatible with the latest version of Excel or that certain functions or APIs have changed. In such cases, you may need to update the VBA code to ensure compatibility with Microsoft 365.

As a best practice, always exercise caution when enabling or running macros, especially if they come from unknown or untrusted sources, as malicious macros can pose security risks. Review the code and only enable macros from sources you trust.

If you encounter specific error messages or issues with your VBA macros, feel free to provide more details, and I can try to offer more targeted assistance.

If you have any further questions or need additional assistance, please feel free to ask. I'm here to help!

If the reply was helpful, please don’t forget to upvote or accept it as an answer, thank you

Kind regards Ajibola