Share via

VBA Macros in Excel iOS

Anonymous
2018-03-04T23:49:48+00:00

When I open the file containing the macros, which I downloaded from this URL: https://payhip.com/d/l/6b264b8e0d70d6a5396d25c7688e5c39ab91cb49, it says that “This version of Microsoft Excel can’t run VBA macros, as shown in the below screenshot.

When I tap on “Build Tables”/“Clear draws” a warning box as shown in the screenshot below appears on the screen.

For your reference, I am using the most recent version of Microsoft Excel (version 2.10.1)

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2018-03-05T07:29:08+00:00

    Hi there Michael, 

    I don't know if you know about 'macro's' but it is a code in VBA (Visual Basic for Applications) which expands the use of Excel. I see you are using an iPad to open the file and that is where the problem kicks in.

    Unfortunately excel for IOS devices (iPad, Iphone etc.) doesn't support this function (yet). If you really need the macro's to function it is advised to open the file within a windows or osx version of excel. 

    You can also recognize an excel file with macro's to the extension, which is xlsm (instead of .xls or xlsx). 

    Good luck!

    220 people found this answer helpful.
    0 comments