Share via

.xlsm file not opening with macro enabled from SharePoint

Dhaval Gandhi 0 Reputation points
2023-02-16T03:51:47.76+00:00

Hi, We have our company SharePoint site. I have created one .xlsm file which has a first page VBA script to enter the data which are getting stored in other sheets of the same file. I've uploaded that file into my SharePoint page for data entry operator's to do the data entry. I wanted to give them a short cut of that file from SharePoint on their desktop so that they can click on the shortcut and directly open that file to enter the data in the scripted form on sheet 1. The problem is there are able to open the file from the shortcut but the VBA script is not enable so they are not able to click on the form and enter the data. VBA scripted form on Sheet 1

Data entry form created for users

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,795 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Yanli Jiang - MSFT 26,681 Reputation points Microsoft Vendor
    2023-02-16T07:16:46.79+00:00

    Hi @Dhaval Gandhi ,

    According to my research, many Office functions are not supported on the web, such as Excel macros and custom scripts. It is recommended that you use the Excel client to open the file.

    02168

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.