Excel 2007 and Macros
 

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

Excel 2007 and Macros
 

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

Excel 2007 and Macros
 

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

Excel 2007 and Macros
 

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

Excel 2007 and Macros
 

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