Re: Excel 2007 and Macros

Tech-Archive recommends: Speed Up your PC by fixing your registry

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: Macro Xcel Windows
    ... If using XL97, macro security is on or off, no levels. ... Before setting your security to "low" which will let every file with macros ... You can create a digital certificate and use that on your VBAProject so only ... that file with the certificate is allowed to be opened with no warning. ...
    (microsoft.public.excel.misc)
  • macros with expired or revoked signature
    ... Thank you for your help but if I set Security to Medium ... >which means that no macros will be enabled. ... You will now get a warning ...
    (microsoft.public.word.application.errors)
  • Re: Disabling Macro Warning
    ... If your security is set to high then you will not get a warning. ... That is the whole point to the medium setting. ... If macros are digitally signed, ...
    (microsoft.public.excel.misc)
  • Re: Macros, XP
    ... If the warning message suggests that security is set high and macros ... Set the macro security to medium, which provides the option of running ... >> Office 97 due to my work environment that I haven't taken the time ...
    (microsoft.public.word.newusers)
  • Re: C++ Compiler with a -Wwarn-use-of-strcpy or similar option??
    ... macros to watch the string and memory routines and inform at ... similar macros used to track memory leaks and similar offenses ... The macro does compile time checking ... As a general rule you should compile with the maximum warning ...
    (comp.lang.cpp)