[FONT=monospace, serif]Guys,[/FONT]
[FONT=monospace, serif]On my work machine I was running XP and 2007 Excel. While we migrated to 2010 Excel and Windows 7 Enterprise I needed to use a few project plans.[/FONT]
[FONT=monospace, serif]These contained a few macros and were password protected docs.[/FONT]
[FONT=monospace, serif]I use Excel 2016 at home so just opened them on USB.[/FONT]
[FONT=monospace, serif]Now when I try and open them on Excel 2010 I get the following message:[/FONT]
This file contains encrypted macros that have been disabled because there is no antivirus software installed that can scan them. To run these macros, remove the encryption or permission restrictions on this file.
[FONT=monospace, serif]I have followed the REGEDIT method and tried both DWORD and QWORD options as the machine is a 64BIT. I can access REGEDIT as I have developer rights.....[/FONT]
[FONT=monospace, serif]However most stuff is locked down so I cannot even make the doc trusted, or add a trusted location.
Is there anyway round this?
Sorry to ask guys but I have been searching for a few hours!
THANK YOU!!! [/FONT]
[FONT=monospace, serif]On my work machine I was running XP and 2007 Excel. While we migrated to 2010 Excel and Windows 7 Enterprise I needed to use a few project plans.[/FONT]
[FONT=monospace, serif]These contained a few macros and were password protected docs.[/FONT]
[FONT=monospace, serif]I use Excel 2016 at home so just opened them on USB.[/FONT]
[FONT=monospace, serif]Now when I try and open them on Excel 2010 I get the following message:[/FONT]
This file contains encrypted macros that have been disabled because there is no antivirus software installed that can scan them. To run these macros, remove the encryption or permission restrictions on this file.
[FONT=monospace, serif]I have followed the REGEDIT method and tried both DWORD and QWORD options as the machine is a 64BIT. I can access REGEDIT as I have developer rights.....[/FONT]
[FONT=monospace, serif]However most stuff is locked down so I cannot even make the doc trusted, or add a trusted location.
Is there anyway round this?
Sorry to ask guys but I have been searching for a few hours!
THANK YOU!!! [/FONT]