thbutterflycollector_
New Member
- Joined
- Oct 29, 2015
- Messages
- 43
- Office Version
- 365
- Platform
- Windows
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
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