Re: 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" <jrrech@xxxxxxxxxxx> wrote in message
news:ee0APQPgHHA.4980@xxxxxxxxxxxxxxxxxxxxxxx
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" <None@xxxxxxxxxxx> wrote in message
news:OWjxKjNgHHA.4260@xxxxxxxxxxxxxxxxxxxxxxx
| 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
|
|
|




.

Relevant Pages

  • Re: Excel 2007 and Macros
    ... reinstall and see if I can reset the Security that way. ... run macros without any warnings. ... There are also settings here but I think these just reflect the settings ... Security warning doesn't appear.....although that's as expected. ...
    (microsoft.public.excel.misc)
  • RE: security alert on macro-enabled worksheet
    ... This does not help...if I do that, it doesn't show the security warning ... The macros are an integral part of the spreadsheet's function ... as a "macro-enabled spreadsheet" in the first place. ... Click Trust Center, click Trust Center Settings, and then click Message Bar ...
    (microsoft.public.excel.misc)
  • Re: Stop Word from capitalizing new lines
    ... Setting the AutoCorrect options should work, ... If the options settings don't hold, the AutoNew and AutoOpen macros really ... That would prevent the macros from running at all. ... - How do I stop Word from capitalizing the first letter of a new ...
    (microsoft.public.word.docmanagement)
  • Re: Normal.dot and deletion of ~*normal.dot, recycle bin
    ... SECURITY WARNING after several seconds. ... Regarding the prompts to enable macros and such. ... installed add-ins and templates" back on and you won't encounter the ... I turned PROMPT TO SAVE NORMAL TEMPLATE back on. ...
    (microsoft.public.office.misc)
  • Re: Print button on toolbar linked to specific printer, way to do?
    ... have no administrative control over this colourjet, ... this can be done on a network printer, I'd really, really ... >Actually I think that will work better as the macros I ... >the settings that I need? ...
    (microsoft.public.excel.misc)
Loading