MACRO inside PROTECTED FILE - Please help
 

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.

MACRO inside PROTECTED FILE - Please help
 

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...
--
Thanks,
Shane Devenshire


"ivo" wrote:

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.

MACRO inside PROTECTED FILE - Please help
 

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


"ShaneDevenshire" wrote in
message ...
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...
--
Thanks,
Shane Devenshire


"ivo" wrote:

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.

MACRO inside PROTECTED FILE - Please help
 

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 wrote:

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

"ShaneDevenshire" wrote in
message ...
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...
--
Thanks,
Shane Devenshire


"ivo" wrote:

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.





--

Dave Peterson

MACRO inside PROTECTED FILE - Please help
 

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\E xcel\Security\ExcelBypassEncryptedMacroScan

Set the value to 1.

--
Jim
"ivo" wrote in message
...
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


"ShaneDevenshire" wrote in
message ...
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...
--
Thanks,
Shane Devenshire


"ivo" wrote:

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.

MACRO inside PROTECTED FILE - Please help
 

If I only hit refresh before posting! <g

--
Jim
"Dave Peterson" wrote in message
...
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 wrote:

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

"ShaneDevenshire" wrote in
message ...
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...
--
Thanks,
Shane Devenshire


"ivo" wrote:

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.





--

Dave Peterson

MACRO inside PROTECTED FILE - Please help
 

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" wrote in message
...
If I only hit refresh before posting! <g

--
Jim
"Dave Peterson" wrote in message
...
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 wrote:

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

"ShaneDevenshire" wrote in
message ...
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...
--
Thanks,
Shane Devenshire


"ivo" wrote:

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.





--

Dave Peterson

MACRO inside PROTECTED FILE - Please help
 

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

Jim Rech wrote:

If I only hit refresh before posting! <g

--
Jim
"Dave Peterson" wrote in message
...
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 wrote:

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

"ShaneDevenshire" wrote in
message ...
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...
--
Thanks,
Shane Devenshire


"ivo" wrote:

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.





--

Dave Peterson

--

Dave Peterson

MACRO inside PROTECTED FILE - Please help
 

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





ivo wrote:

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" wrote in message
...
If I only hit refresh before posting! <g

--
Jim
"Dave Peterson" wrote in message
...
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 wrote:

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

"ShaneDevenshire" wrote in
message ...
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...
--
Thanks,
Shane Devenshire


"ivo" wrote:

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.





--

Dave Peterson



--

Dave Peterson

MACRO inside PROTECTED FILE - Please help
 

that means that if someone does not have AV program, he would not have
problems.

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
"ivo" wrote in message
...
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" wrote in message
...
If I only hit refresh before posting! <g

--
Jim
"Dave Peterson" wrote in message
...
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 wrote:

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

"ShaneDevenshire" wrote in
message ...
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...
--
Thanks,
Shane Devenshire


"ivo" wrote:

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.





--

Dave Peterson