Question: I added an Excel workbook with multiple tabs to SharePoint. The workbook has macros that protect and unprotect the worksheets, which work perfectly on my local machine but stop functioning once uploaded to SharePoint. Is there a way to make this work, or is it not feasible? Any advice would be greatly appreciated.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Protecting and Unprotecting Worksheets in Excel
- Thread starter Michnia25
- Start date
Candyman8019
Well-known Member
- Joined
- Dec 2, 2020
- Messages
- 1,082
- Office Version
- 365
- Platform
- Windows
Once in SharePoint, if it opens in Excel for web, macros will not run. It must be running in the desktop app.
You can force it to open in the desktop app. In SharePoint, there is a setting...you may need the site owner to change it if you don't have access.
You can force it to open in the desktop app. In SharePoint, there is a setting...you may need the site owner to change it if you don't have access.
Upvote
0
Similar threads
- Solved
- Solved
