Spreadsheet with macros blocked by security

christianbiker

Active Member
Joined
Feb 3, 2006
Messages
365
Greetings all,

I have an issue with Excel in Office 365. My company just upgraded from Excel 2013 to Office 365 (Excel 2016). Now I am having issues with macros. My form has an email function built in that is ran by clicking on a button. The email is sent to a different organization when executed. With Excel 2013 they received the spreadsheet as an attachment and had no problems opening it. Now, under Excel 2016, that same spreadsheet is blocked entirely by that organizations' security software. Why would this happen with the newer version of Excel but not the older version? It sucks and any assistance would be greatly appreciated.

Thanks!
 

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.
My original post stated...


I have an issue with Excel in Office 365. My company just upgraded from Excel 2013 to Office 365 (Excel 2016). Now I am having issues with macros

Thought it was pretty clear that the issue arose when we switched.
 
Upvote 0
I was just trying to help.

This was your second post, so I went a different direction to try to help
As I mentioned...this is being sent to an outside organization and their email totally blocks the attachment.

I have office 2013 at home. I share files with others that have office 2016 and office 365. Nothing has prevented them from reading the files I send to them and nothing has prevented me from reading the files from them. The files are rife with macros and laden with formatting on the sheets.

Jeff
 
Upvote 0

Forum statistics

Threads
1,214,940
Messages
6,122,352
Members
449,080
Latest member
Armadillos

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top