Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing Security Level in Excel | Excel Discussion (Misc queries) | |||
Macro security level in excel will not change | Excel Discussion (Misc queries) | |||
Macro security level in excel will not change | Setting up and Configuration of Excel | |||
Test For Macro Security Settings Level | Excel Programming | |||
Excel 2000 macro security level | Excel Programming |