MACRO inside PROTECTED FILE - Please help

[ivo]

I really can't believe it's happening. I have file that is protected form
opening and inside the file are macros. My Excel 2007 doesn't allow me to
execute these macros when file is protected. The fact that i put my file in
folder which I put inside Tructr Center location, but this doesn't help
also.
Only, when I remove password, everything is OK.
Please is there any advice for me? File must have password.

 

[ShaneDevenshire]

Hi Ivo,

I password protected an Excel 2007 file containing a macro and have no
problem running the macro.

Exactly what kind of protection are you putting on?
1. File, Save As, Tool, General Options, Password to Open
2. Review, Sheet Protection
3. Review, Protect Workbook...
4. Review, Share Workbook...

 

[ivo]

Thanks Shane
i use first of your these you wrote
i really cannot understand that because it is stupid. If someone already
entered my file, why should not be possible to run macro

 

[Dave Peterson]

Jim Rech posted this:

When a password protected workbook is opened in Excel 2007 macros are
automatically disabled, presumably because the macros cannot be scanned due
to the file being encrypted.

Setting this dword registry key to 1 will turn that feature off:

HKCU\Software
\Microsoft
\Office
\12.0
\Excel
\Security
\ExcelBypassEncryptedMacroScan

 

[Jim Rech]

MS decided that since an encrpyted file cannot be scanned for viruses they
would just disable macros in them.

A registry entry can change this:

(Dword)

HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Security\ExcelBypassEncryptedMacroScan

Set the value to 1.

 

[Jim Rech]

If I only hit refresh before posting! <g>

--
Jim

Jim Rech posted this:

When a password protected workbook is opened in Excel 2007 macros are
automatically disabled, presumably because the macros cannot be scanned
due
to the file being encrypted.

Setting this dword registry key to 1 will turn that feature off:

HKCU\Software
\Microsoft
\Office
\12.0
\Excel
\Security
\ExcelBypassEncryptedMacroScan

 

[ivo]

thank you. That is very possible the reason of my problem.
But, that means that if someone does not have AV program, he would not have
problems.

and please, can you tell me how to reach to this registry?

If I only hit refresh before posting! <g>

 

[Dave Peterson]

I did edit your post--just to avoid any line wrap problems.

 

[Dave Peterson]

Nope. Excel wants to look at your file.

Close excel
click on the windows start button
Click on Run
type
Regedit
and hit ok

You should see a right and left hand side in the window that just opened--kind
of like Windows explorer.

Click on the + in front of each "branch" to open that branch.
Start on HKEY_CURRENT_USER
(directly under "My Computer" (the top level))

Click on each of these in order:
HKCU\Software
\Microsoft
\Office
\12.0
\Excel
\Security

Once you expand the Excel level, you'll see Security.
Rightclick on that Security key
Click New...
Choose DWord
Type this in as the name:
ExcelBypassEncryptedMacroScan
(I'd cut and paste from this message to avoid typos)
Hit enter to finish your name change
Doubleclick on that new entry.
Change the 1 to 0
and click ok
(you don't have to worry about the Base--hexadecimal and decimal don't matter
here)


You're done.

Close this window

Start up excel and test it out.

=====
Just a warning. Be careful when you do this. You'll notice that there are not
many "Are you sure prompts". If you delete something that you shouldn't or
change something that you shouldn't, you could screw something up.

But with a little bit of care, you should be ok.

You may want to make a back up of the registry before you start.

You can do this by opening Regedit and then
File|Export
Export the whole thing (All under the "Export Range" option at the bottom

thank you. That is very possible the reason of my problem.
But, that means that if someone does not have AV program, he would not have
problems.

and please, can you tell me how to reach to this registry?

 

[Jim Rech]

that means that if someone does not have AV program, he would not have
No it doesn't. Everyone will have this issue. Excel goes by whether the
file can be scanned not whether it will be scanned.

To edit the registry: From Start->Run enter "regedit.exe" (no quotes).

--
Jim

thank you. That is very possible the reason of my problem.
But, that means that if someone does not have AV program, he would not
have problems.

and please, can you tell me how to reach to this registry?