Share via

Seeking information on Excel/VBA functionality supported for shared excel workbooks?

Anonymous
2024-02-15T22:39:06+00:00

Hello,

I've built an Excel workbook with VBA macros that is being used shared by multiple users.

Often it becomes corrupt and has problems saving. It resides on a Sharepoint server but is being opened via Excel to allow the VBA code to run. OneDrive is being used to sync.

The workbook is password protected. Autosave is enabled. The VBA macros in essence do two things: i) hide/unhide/resize/add rows, and ii) unprotect/protect worksheets to do this.

Are all of these functions supported by Sharepoint and Onedrive?

Kind regards,
Chris.

Microsoft 365 and Office | SharePoint | 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 No comments

1 answer

Sort by: Most helpful
  1. Anonymous
    2024-02-16T02:32:26+00:00

    Was this answer helpful?

    0 comments No comments