Thanks so much for your time on this Jim. I think I might remove office and
reinstall and see if I can reset the Security that way. I think it was
working properly at first until I started mucking around with making My
Documents a trusted zone.

I don't have anything in the registry that starts with HKCU. All that my
registry contains start with HKEY (of which there are 5).

Rob

"Jim Rech" wrote in message
...
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\Commo n\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
"Rob" wrote in message
...
| 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
|
| "Jim Rech" wrote in message
| ...
| 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
| "Rob" wrote in message
| ...
| | 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
| |
| |
| |
|
|
|
|