question

AlexanderToresson-7074 avatar image
0 Votes"
AlexanderToresson-7074 asked JoyZ commented

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

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

office-sharepoint-online
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

JoyZ avatar image
0 Votes"
JoyZ answered JoyZ edited

@AlexanderToresson-7074,

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.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AlexanderToresson-7074 avatar image
0 Votes"
AlexanderToresson-7074 answered JoyZ commented

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

· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@AlexanderToresson-7074,

Per my research, we could not connect a script to a figure in sharepoint.

1 Vote 1 ·

HI, I've found some threads with same result.
Do you think this feature will be available at all?

0 Votes 0 ·
JoyZ avatar image JoyZ AlexanderToresson-7074 ·

@AlexanderToresson-7074,

Currently this is not available in SharePoint Online.

If you find any replies helpful to you, please remember to accept them as answers.

It will help others who meet the similar question in this forum.

Thank you for your understanding.

0 Votes 0 ·