close

hi, I set Excell 2003 macro security to low and works untill I close excell,
once I close and re-open it is going back to medium.
how I can make it to stay in low.

thanks

manny

This is a setting that gets stored in the windows registry.

It sounds like you don't have permission to save it. I'd speak with the IT
folks and ask why.

djruby14 wrote:
gt;
gt; hi, I set Excell 2003 macro security to low and works untill I close excell,
gt; once I close and re-open it is going back to medium.
gt; how I can make it to stay in low.
gt;
gt; thanks
gt;
gt; manny

--

Dave Peterson



quot;Dave Petersonquot; wrote:

gt; This is a setting that gets stored in the windows registry.
gt;
gt; It sounds like you don't have permission to save it. I'd speak with the IT
gt; folks and ask why.
gt;
gt; djruby14 wrote:
gt; gt;
gt; gt; hi, I set Excell 2003 macro security to low and works untill I close excell,
gt; gt; once I close and re-open it is going back to medium.
gt; gt; how I can make it to stay in low.
gt; gt;
gt; gt; thanks
gt; gt;
gt; gt; manny
gt;
gt; --
gt;
gt; Dave Peterson
gt;
hi could you please let me know which is the registry key?
thanks
manny

Saved from a previous post:

The Excel security setting is saved in the registry under this key:

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 quot;Levelquot;. You'd set this to 2 for medium

===

and just to add: 1 = low, 2 = medium, 3 = high.
And 11.0 is xl2002.

So for xl2k, you'd want 10.0

djruby14 wrote:
gt;
gt; quot;Dave Petersonquot; wrote:
gt;
gt; gt; This is a setting that gets stored in the windows registry.
gt; gt;
gt; gt; It sounds like you don't have permission to save it. I'd speak with the IT
gt; gt; folks and ask why.
gt; gt;
gt; gt; djruby14 wrote:
gt; gt; gt;
gt; gt; gt; hi, I set Excell 2003 macro security to low and works untill I close excell,
gt; gt; gt; once I close and re-open it is going back to medium.
gt; gt; gt; how I can make it to stay in low.
gt; gt; gt;
gt; gt; gt; thanks
gt; gt; gt;
gt; gt; gt; manny
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Dave Peterson
gt; gt;
gt; hi could you please let me know which is the registry key?
gt; thanks
gt; manny

--

Dave Peterson

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()