Excel Scripts Permissions Issue - Macro Workaround?

[thbutterflycollector_]

Hi,

I've created a script in Excel to help automate the adjustment to table sizes across two worksheets. I have shared this outside my organisation, the workbook is macro-enabled and I've got my IT Department to certify it as a trusted macro. However, the Scripts disappear when someone outside the company opens the file. I have added a button. I've since checked and a different outside organisation is not reporting any issues. The message I am getting is "the button cannot run because the script was unshared. Contact the owner to share again"

Does anyone have any idea why this is happening? I am wondering whether the Scripts are too much hassle and whether I should actually go about creating a macro based on the script - can anyone advise how I can go about that? I can't seem to find anything on the web to point me in the right direction.

Thank you

 

[Sam_D_Ben]

Please try Excel vba and see if it work. I guess Office scripts got limitations in your case. Thank You