I have tried to reproduce your scenario, Rob, but I find that macro security
is working as expected.
After I add a new location to Trusted Locations both XLS and XLSM files
(created from the XLS as you did it) run macros without any warnings.
Since there seems to be a setting somewhere that is different for you than
me and this setting is evidently not accessible through the UI, I suppose it
could be a 'policy' setting. If you want to explore that, try running
RegEdit.exe from Start->Run and poke around this key (assuming you have
admin rights on your machine):
HKCU\Software\Policies\Microsoft\Office\12.0\Common\Security
This should be empty I think.
There are also settings here but I think these just reflect the settings you
can change through the UI:
HKCU\Software\Microsoft\Office\12.0\Excel\Security
There may be security settings that Office uses in the HKLM registry branch
too. You might search that for "policy" and see what you find.
I don't know what else it can be.
--
Jim
| Hi Jim,
|
| I looked at every setting and discovered that I'd added the My Documents
| folder and its subfolders to the trusted locations. I'd forgotten I'd
done
| that. BUT, that makes the problem even stranger as the workbooks open
with
| the macros disabled if I open it from within any of those "trusted
folders".
|
| If I copy the file to my desktop (untrusted) and open it, I do get a
| security warning and I get the option to Enable content. I never get the
| option "Trust all documents from this publisher" appearing anymore.
| Another strange variation is that one of the files I had converted to xlsm
| never gives any other option except "Help protect me from unknown
content."
| The only way to get the macros working is to reopen the xls version and
| resave as xlsm. It seems the options within the Security Centre are
causing
| some problems and are not resetting the security warnings correctly when
| reverting to original options.
|
| As soon as I make the My Documents folder and its subfolders trusted
again,
| these situations occur.
| 1. Security warning doesn't appear.....although that's as expected.
| 2. Any xls files opened from the trusted folders work fine.
| 3. Any xls files I subsequently convert to xlsm, close and reopen have the
| macros disabled and there is no option to enable.(When I initially save to
| xlsm the macros work until I close and reopen that xlsm file.)
|
| The settings within the security centre are as follows:
| Message Bar: Show.......is selected
| Macro Settings: Disable all macros with notification OR Enable all
| macros......makes no difference which is selected
| Developer Macro Settings: Trust...... is ticked.
| Trusted Locations: Allow.... is ticked
| Path: I have added .....C:\Documents and Settings\Nobel\My Documents\
| (sub folders allowed)
|
| Rob
|
| | > So if you set the Trust Center macro security option back to Disable
with
| > Warning, do you not get a Security Warning bar appearing above the
formula
| > bar? This should allow you to enable the macros.
| >
| > --
| > Jim
| > | > | Wow, what a confusing change Excel 2007 is over its predecessors!!
| > |
| > | My main battle is trying to get macros to run after saving to the new
| > | format.
| > |
| > | The macros run fine if I open as an xls, but if I save as xlsm and try
| > to
| > | run the macros I get a message stating that the macros may not be
| > available
| > | or may be disabled. I checked, and the macros are still there but I
| > can't
| > | run them.
| > |
| > | When I first installed Office 2007 I used to get a message warning
about
| > the
| > | macros and giving me options to allow, etc., but that warning never
| > appears
| > | anymore. I suspect after I went into the Trust Centre and set the
| > option
| > to
| > | enable all macros things went south after that. I checked all the
| > security
| > | settings, etc., but I never get a warning about macros. They are just
| > | disabled (unless I leave it as an xls file).
| > |
| > | Please help. I don't want to uninstall and reinstall. I did try the
| > repair
| > | option which made no difference.
| > |
| > | Rob
| > |
| > |
| > |
| >
| >
|
|
