security Level settings in Excel
 

I have a client that's using Microsoft Excel 2003 to do programming for his
group, he's encountering the default setting in
Tools---Macro---Security---Security Level. Default is "Medium", when he
sets it to 'Low', it keeps going back to "Medium"??.

We've had issues like this before in our environment (1200+) with users,
doing different manipulations of the product (Excel) for their group (s). How
can we (Desktop Support) make and/or change "Default-Medium"?. I know, this
not the norman for the Mfg/Microsoft, to make changes such as this request if
they haved heard of it before. I thank you in advance.

Much regards,
Jules Sainte/Dsktp Spprt
Siemens IT Solutions

security Level settings in Excel
 

I guess thats problem came from the user setting perhaps not administrator
that caused unstable changing in security value.

you can try bypass it by using regedit command:
open this key
HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\E xcel\Security
then change Level value to:
1 -- Low
2 -- Medium
3 -- High
4 -- Very high (Excel 10 and later) CMIIW

--
Regards,

Halim



"Jules Sainte" wrote:

I have a client that's using Microsoft Excel 2003 to do programming for his
group, he's encountering the default setting in
Tools---Macro---Security---Security Level. Default is "Medium", when he
sets it to 'Low', it keeps going back to "Medium"??.

We've had issues like this before in our environment (1200+) with users,
doing different manipulations of the product (Excel) for their group (s). How
can we (Desktop Support) make and/or change "Default-Medium"?. I know, this
not the norman for the Mfg/Microsoft, to make changes such as this request if
they haved heard of it before. I thank you in advance.

Much regards,
Jules Sainte/Dsktp Spprt
Siemens IT Solutions

security Level settings in Excel
 

If you were interested... here is a version independent VB Script that you
can run to alter these settings:

Option Explicit
Dim objShell, RegLocate, myVersion, objExcel
Set objExcel = CreateObject("Excel.Application")
myVersion = objExcel.Version
Set objShell = WScript.CreateObject("WScript.Shell")
On Error Resume Next
RegLocate = "HKEY_CURRENT_USER\Software\Microsoft\Office\" & myVersion &
"\Excel\Security\Level"
objShell.RegWrite RegLocate,"1","REG_DWORD" ' 1 for LOW, 2 for MEDIUM, 3
for HIGH
objExcel.Quit
WScript.Quit

Also, Jon Peltier had posted some other information on this topic as well.
Here is the information he posted on this topic (see the correspondences
below):

----- Original Message -----
From: "Jon Peltier"
Newsgroups:
microsoft.public.office.developer.vba,microsoft.pu blic.excel.programming,microsoft.public.excel.misc ,microsoft.public.excel
Sent: Sunday, March 04, 2007 9:59 AM
Subject: how to get around the Enable Macro security message?


A very nice example of this is found in chapter 20 of the Professional
Excel Development book by Bullen, Bovey, and Green. Under the Practical
Examples at the end of the chapter, look for "Standard EXE - Creating a
Front Loader for Your Excel Application". This book is full of many
practical examples like this one.

Here's a link to the book:
http://www.amazon.com/exec/obidos/re...&creative=9325

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Jon Peltier" wrote in message
...
Another option is to write a program in VB which opens the workbook for
you. Workbooks which open through automation are implicitly trusted,
since the program that opens them (the VB program) are assumed to have
been opened on purpose.

This approach is good for unsophisicated users, as you can put an icon
for the VB program on the desktop for the users to launch the program.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"cfman" wrote in message
...
HI all,

When the users open my Excel/VBA sheet, they met with a window asking if
Macro should be enabled.

My users are not that sophisticated... so I would like everything simple
for them. Is there a way to get rid of such complications?

Thanks