Excel 10 Macros Disabled

[btadams]

So we finally got Excel 10 rolled out and find that all files with macros are automatically disabled. Except for a .xlsb file that contains copies of macros I had stored in my Personal.xls macro workbook. When I open the .xlsb file I get the option to Enable Macros. However, if I take a .xlsm file and save it as a .xlsb, I only get the option of disabling macros when I re-open it. Does anyone know why this one .xlsb file is getting special treatment and skirting the admin's setting?

Thanks,

Brian

 

[shg]

Create an add-in.

https://msdn.microsoft.com/en-us/li...#UsingVBAToCreateAddins_CreatingVBAAddinFiles

 

[rlv01]

It was most likely a deliberate action implmented via my company's IT folks.

Are you sure it was deliberate? It might be worth a discussion with them. If it was my company, I'd have a conversation with IT if they disabled Excel macros.