365 best solution for running macros

[cogswel__cogs]

Hi,

We are switching over to 365, I have written bunch of macros for group which a few people run. What is best solution for them to run. In 365.
Do I digital Sign the macros or make see if a location on the network can be set as trusted Or something else?

I tried to set a file with a digital signature but when I think I need to be Admin. Do I?


As always Thanks for any help.

 

[rlv01]

Assuming you are switching to the desktop verion of Excel 365 (not the web version), your macros will probably run as-is.

 

[cogswel__cogs]

Yes they seem to be okay. I had to set trusted locations so people could access.

 

[rlv01]

We went through it a few years ago. Mostly no drama.

 

[cogswel__cogs]

Yeah at first I freaked out because on line it seemed difucult but that must have been online version. Well at least it got me to start signing my code, I thought that was gonna help.

 

[rlv01]

The Excel 365 web version does not use VBA for macros. It uses TypeScript/OfficeScript which I believe is a flavor of javascript.