xlsm macros

  • Thread starter Thread starter barglen
  • Start date Start date
B

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?
 
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.
 
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 said:
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.
Click to expand...
 
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
| >
| >
| >
 
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?
 
PS Forgot to mention a Thanks to Jim for his solution - that does fix the
problem for me on this machine....
 
Back
Top