September 2, 2022
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.
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.