2007 XP to 2010 W7 - Encrypted Macro Problem! Please help!! :)

Orange777

New Member
Joined
Jul 4, 2015
Messages
16
[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]
 

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

Forum statistics

Threads
1,223,236
Messages
6,170,912
Members
452,366
Latest member
TePunaBloke

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