VBA: Show pop-up when Excel file is opened in browser (e.g. SharePoint / OneDrive)

Hi all,

I'm using an Excel file at work that has a lot of macros in it (e.g. to automatically copy content from a to b). Those macros do not work if the file is opened in browser, e.g. via a sharepoint / onedrive link that was shared.
So far, I've always added big fat red letters on every spreadsheet that the file needs to be opened locally, i.e. in client, for it to work properly.
Sadly, this is often ignored so colleagues add content to the spreadsheet, but the macros cannot execute so the file is basically useless from that point.

Is there any way to show a pop-up to remind colleagues to open in client, when the file is opened in browser?
Is there VBA code that can still execute in browser?

I found the following in another forum and it's supposed to tell if the file is read-only or not if opened on sharepoint. Thought maybe this can be tweaked somehow?

Please Login or Register  to view this content.

Any help is appreciated!
Thank you!

Hi rorya & AlphaFrog,

Makes sense...thought so :-(

But I like your suggestion, AlphaFrog! Haven't thought about this! Will give it a try!! Thank you!