Is it possible to connect a script to an figure in Excel sharepoint?

Question

Hi,

Is it possible to connect a script to an figure in Excel sharepoint?

I'm about to go from Excel local file on my computor to Excel Sharepoint.
Thing is, I have over 1k macros/scripts in my file.

In excel (local file) i can connect my macro to a small figure on the sheet. This allows me to have many figues with macros in one sheet without it taking much place.

In excel sharepoint my scripts only saves in a list. I can't go through this list and find correct script everytime i need to use it.
Is it possible to connect a script to a figure in sharepoint?

Br
Alexander

Answer 1

@Alexander Toresson ,

As far as I know, in SharePoint Online, we can open and edit a workbook that contains macros in Excel for the web, however we can't create, run, or edit VBA (Visual Basic for Applications) macros.

We need to open the workbook in the Excel desktop app to view and edit the macros.

More information:

https://support.microsoft.com/en-gb/office/work-with-vba-macros-in-excel-for-the-web-98784ad0-898c-43aa-a1da-4f0fb5014343?ui=en-us&rs=en-gb&ad=gb

https://support.microsoft.com/en-us/office/differences-between-using-a-workbook-in-the-browser-and-in-excel-f0dc28ed-b85d-4e1d-be6d-5878005db3b6

---

If an Answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

I say completely opposite. :)

• I can't open a workbook with existing macros, because they will be gone.
• I can create new "Scripts" but i can't connect them to figures.

If I create a macro-available Excel file on my local desktop and create 2-4 different, basic, macros and then upload the file in Sharepoint, my macros are gone in the Online-excel version in Sharepoint.

In the desktop version I'm also able to connect the macro to a figure, for example a square. When I press the square, my macro is activated.
This Is the solution i need to have in Excel online version in Sharepoint.

If I create a new online excel file in Sharepoint I'm able to create new macros. They are now called Scripts. Problem Is, the scripts are only saved in a list. I can't connect the scripts to a figure, like my square in the example above. In the end, I can't scroll the list to find correct macro to activate it because I need too many Scripts/macros.

Today, I have a desktop file with over 1-2k macros attached in figures. When I'm the only one working in this file It's all fine.
Now we're about to be 4 persons working in my file and I can't have It on my desktop anymore.
I need to make the file shared, in Sharepoint, for example with Scripts/macros attached in the figures.

Any idea how to solve my issue?

Br
Alexander