Share via

Can we enable VBA Macro on Web Excel? or allow only desktop editing on shared workbook?

Anonymous
2023-03-09T05:11:30+00:00

My workbook has VBA Marco code for validation, and we share this with multiple users on Teams. But no validation is working on web version and all users are still allowed to enter wrong details. Is there any way to enable Marco validation on Web version, and if not, by any means I can restrict web editing for users, so that, they only can do it on desktop mode?

Microsoft 365 and Office | Excel | For business | 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
    2023-03-09T09:30:00+00:00

    Dear Mohit Jaiswal,

    Good day! Thank you for posting to Microsoft Community. We are happy to help you.

    Can we enable VBA Macro on Web Excel？

    According to my investigation as well as the instructions of the official documentation. We really can't run VBA in Excel Web：Work with VBA macros in Excel for the web - Microsoft Support

     

    If not, by any means I can restrict web editing for users, so that, they only can do it on desktop mode?

    Based on my testing and investigation, using the Protect Workbook feature meets your needs that prevent users from editing on the web.

    The following message appears in Excel on the web, and the password cannot be removed in the web version

     

    Ref :Office Online - Restrict Editing - Microsoft Community

    Sincerely,

    Tin | Microsoft Community Moderator

    0 comments