New Member
September 2, 2022
Hi everyone,
I want to share my excel VBA file to OneDrive so that shared people can edit/use my macro live (without downloading the file). When shared to Onedrive, my colleague, will get this warning message in excel Picture. The "solution" i found is this Link. Is there a solution without downloading the file.
Sorry for my broken English, hope you understood my explanation and thank you in advance.
BR, Tapio
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
November 8, 2013
Macros cannot run in Onedrive and cannot be edited in Excel Online. You cannot edit a macro without opening the file on desktop, not sure why you want to edit/run without opening, does not make sense.
If you just want another way to avoid macros being blocked, generate a self signed certificate, send it to all users so they can install it on their computer.
Sign the vba project with this certificate, you will not see that error if the project is digitally signed and the certificate is properly installed.
1 Guest(s)