Spreadsheet with macros blocked by security

christianbiker

Active Member
Joined
Feb 3, 2006
Messages
360
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!
 

Some videos you may like

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

Jeffrey Mahoney

Well-known Member
Joined
May 31, 2015
Messages
1,768
It looks like your tagline needs updating :)

Go to File - Options - Trust Center - Trust Center Settings - Macro Settings

If you can change the options, most likely everybody in your company can also. I personally set mine to "Enable All Macros"

If you can't change the options. Your IT department needs a lesson on how important it is to have macros allowed. Good Luck

Nope, there is no way to have a macro change that!!

{Tail wagging the Dog}
 

christianbiker

Active Member
Joined
Feb 3, 2006
Messages
360
As I mentioned...this is being sent to an outside organization and their email totally blocks the attachment. But...it never did that with Excel 2013. Something has been changed in Excel 2016 and I am hoping there is a reason for it that can be avoided.
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
46,210
Office Version
  1. 365
Platform
  1. Windows
Are you sure that the other company haven't changed something at their end?
 

christianbiker

Active Member
Joined
Feb 3, 2006
Messages
360

ADVERTISEMENT

Yes because some people in my organization were upgraded to Excel 2016 months ago and the spreadsheet hasn't worked for them since. I was using Excel 2013 till today and the attachment always went through. There must be something that changed in Excel 2016 or the code that I obtained from Ron De Bruin may have a portion that is outdated for use in Excel 2016.
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
46,210
Office Version
  1. 365
Platform
  1. Windows
Does your code strip out all the VBA in the workbook?
 

Jeffrey Mahoney

Well-known Member
Joined
May 31, 2015
Messages
1,768

ADVERTISEMENT

This is an email Issue!!! Not an excel issue. The company has a block on macro workbooks.

Use this at your own peril.

Zip the file. Change the extension of the Zip file to .zap. Send it to your co-worker explaining that they need to save the file to a folder and rename the file back to .ZIP. Then they have to unzip the file before using it.

Alternative: Load it to your Google Drive and send a link to your co-workers.

Alternative: Ask upper mangement to tell the IT depeartment to reconsider blocking .xlsm files because you're just tryin to get your work done.

Jeff
 

christianbiker

Active Member
Joined
Feb 3, 2006
Messages
360
@ Jeff

Please read my posts. The issue only arose when I was upgraded to Office 365. Spreadsheets with macros sent via email in Office 2013 were not blocked in any way, however spreadsheets sent in Office 365 that have macros are blocked. If the other organization blocks spreadsheets with macros it wouldn't matter if they came from Office 2013 OR Office 365.

Zipping the file defeats the purpose of the spreadsheet. Using Ron De Bruins code it is simply an button that activates the macro and automatically emails the spreadsheet to specified people outside my organization. One click it's done. Zipping the file and attaching it manually to an email defeats the purpose of the macro.
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
46,210
Office Version
  1. 365
Platform
  1. Windows
If the code you are using hasn't changed, I can think of no reason why the files would suddenly get blocked, if it still works with 2013.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,817
Messages
5,525,070
Members
409,617
Latest member
Lenaf

This Week's Hot Topics

Top