View Single Post
  #5   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
Dima[_2_] Dima[_2_] is offline
external usenet poster
 
Posts: 12
Default Excel 2003 sticks to the low macro security level

Thanks Dave for suggestion!
This allows to set another than the low level, doesn't it? How to make Excel
remember a setting in its user interface?
Sincerely.
"Dave Peterson" wrote in message
...
If you found that branch in the registry, I wouldn't delete it.

I'd just change it what I wanted:

HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\E xcel\Security

This is for Excel 2003. Should be something similar for other versions.

The item is "Level".
1 = low, 2 = medium, 3 = high.

======
ps. I'm not a IT expert, but it sure sounds more like a problem with the
permissions than excel/Microsoft.

Dima wrote:

Thanks Dave for replying!
I talked to the system and domain administrators. They blame microsoft,
do
not know how to repair.
I've found the http://support.microsoft.com/kb/910817/en-us
Should I delete the
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\11.0\ Excel\Security to
repair?
I have the administrator rights on my Windows XP.
Sincerely.
"Dave Peterson" wrote in message
...
That's one of the settings that's stored in the windows registry.

If it's not sticking, maybe you don't have permission to update the
registry?

Time to talk to the IT folks?????

If you're opening the file manually, you can old the shift (left
shift???)
key
down while you open the workbook.

This won't stop macros in general, but it will stop the auto_open and
workbook_open procedures from running.

Dima wrote:

Hello!
Excel 2003 sp2 and sp3 do not remember the macro security level. Excel
returns the level to low after any change of the level.
How to prevent a macro to run when Excel 2003 sp2 and sp3 open a file
with a
macro?
Best regards
Dima

--

Dave Peterson


--

Dave Peterson