VBA for button to email sheet that can be used online/web version of Excel?

[ubergreen]

I am not sure if this is the correct forum to ask this question.

What I am trying to do is create a VBA button on my sheet that users can click to email the sheet. I want to be able to upload this file/sheet onto OneDrive. However, it seems like OneDrive no longer supports VBA even though it might have in the past.

Does anyone have any suggestions for work arounds to this or maybe alternatives? The only thing that I have come across is maybe power automate can be a potential option? It seems like I would need to have a paid subscription to be able to use Power Automate, which I would prefer to avoid, but would be ok with if it was the only viable option for what I need to do.

 

[Engberg]

You can upload files containing VBA to OneDrive however no VBA can run on the browser version. You'd have to open the file in the desktop app in order to run the VBA in the file.
There is also something called "Office Scripts", which do work on the browser version. I've never used them though, not sure how much you can do with it.

Introduction to Office Scripts in Excel - Microsoft Support

Automate your repetitive tasks with Office Scripts in Excel for the web. Record your actions, then replay them whenever you want. You can also edit your scripts as your workflow changes. Office Scripts are stored in the cloud, letting you update any of your workbooks as needed.

support.microsoft.com

 

[ubergreen]

You can upload files containing VBA to OneDrive however no VBA can run on the browser version. You'd have to open the file in the desktop app in order to run the VBA in the file.
There is also something called "Office Scripts", which do work on the browser version. I've never used them though, not sure how much you can do with it.

Introduction to Office Scripts in Excel - Microsoft Support

Automate your repetitive tasks with Office Scripts in Excel for the web. Record your actions, then replay them whenever you want. You can also edit your scripts as your workflow changes. Office Scripts are stored in the cloud, letting you update any of your workbooks as needed.

support.microsoft.com

Thanks. I'll look into the scripts. I would need the macros to work on the browser version.