xlsm macros

[barglen]

Macros in XL 2007 xlsm spreadsheets that have passwords do not run. Msg says
to re-open and enable the macros at the security prompt however the prompt
does not have an "enable" option.
Searched MS help etc and found a reference indicating that this occurs if a
virus s/w pkg does not scan encrypted macros.
i use norton 360. Checked with Symantec and they indicate nothing to
set/unset in N360 - no answer.
problem exists whether N360 is enabled or disabled - makes no difference.
If I remove the password the macros work.
I'm thinking my only option is to run without the password but perhaps put a
digital signature on the spreadsheet.
any other ideas?

 

[Jim Rech]

There is a registry entry that addresses this if you can get it put on
users' machines:

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

Dword set to 1.

 

[barglen]

Thanks Jim, but does that mean all macros would NOT be checked? So if a dodgy
macro got onto the system nothing would stop it?
--
regards
....barglen

There is a registry entry that addresses this if you can get it put on
users' machines:

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

Dword set to 1.

 

[Jim Rech]

but does that mean all macros would NOT be checked?

Of course not. Encrypted workbooks cannot be scanned so there's nothing to
turn off. Here's the point: Do you want macros in workbooks that cannot be
scanned, because they are encrypted, to run?

--
Jim
| Thanks Jim, but does that mean all macros would NOT be checked? So if a
dodgy
| macro got onto the system nothing would stop it?
| --
| regards
| ...barglen
|
|
| "Jim Rech" wrote:
|
| > There is a registry entry that addresses this if you can get it put on
| > users' machines:
| >
| >
HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Security\ExcelBypassEncryptedMacroScan
| >
| > Dword set to 1.
| >
| > --
| > Jim
| > | > > Macros in XL 2007 xlsm spreadsheets that have passwords do not run.
Msg
| > > says
| > > to re-open and enable the macros at the security prompt however the
prompt
| > > does not have an "enable" option.
| > > Searched MS help etc and found a reference indicating that this occurs
if
| > > a
| > > virus s/w pkg does not scan encrypted macros.
| > > i use norton 360. Checked with Symantec and they indicate nothing to
| > > set/unset in N360 - no answer.
| > > problem exists whether N360 is enabled or disabled - makes no
difference.
| > > If I remove the password the macros work.
| > > I'm thinking my only option is to run without the password but perhaps
put
| > > a
| > > digital signature on the spreadsheet.
| > > any other ideas?
| > >
| > > --
| > > regards
| > > ...barglen
| >
| >
| >

 

[Andy L]

Thanks Barglen for identifying the problem. I am having the exactly same
problem. My issue is that I have a personal password protected workbook file
that I run on different computers (ie home, work etc). In order for my macros
to work will I have to edit the regsitry of every new computer I go on?
Surely there is a better way?

 

[Andy L]

PS Forgot to mention a Thanks to Jim for his solution - that does fix the
problem for me on this machine....