How's everything going with the issue? If the suggestion above was helpful, could you please help mark it as answer to close the thread? If you need further assistance on this, please post back at ease. Office Office Exchange Server. Not an IT pro? Resources for IT Professionals. Sign in. United States English. Ask a question. Quick access. Search related threads.
This object is basically a little spreadsheet that goes in the Form. There is, however, a problem: for each execution of the program the first time that that user form is utilized, the user is presented with a popup window saying "This application is about to initialize ActiveX controls that might be unsafe. If you trust the source of this file, select OK and the controls will be initialized using your current workspace settings. Is there some way to prevent this from happening, for example by making the Spreadsheet a trusted source?
It would be nice if the Macro warning doesn't popup either when the application starts ps. I don't want the macro security level to be set to low, but even setting it to low doesn't prevent the activex warning. Thanks, Taylour. Excel Facts. Easy bullets in Excel. Click here to reveal answer. Joined May 28, Messages 11, From what I recall -- and I definitely don't recall the specifics -- there are certain types of warnings associated with running external processes that simply cannot be avoided.
They are a security measure to try and thwart malicious code. I did some reasearch and found out a little about getting a digital signiture from VeriSign on your Excel application and this prevents the the macro warning. Does anyone know if this will prevent the ActiveX warning as well? Whenever you open it from now on, you will not be presented with a Macro warning. Norie Well-known Member.
Taylour The first solution involves altering the registery - are you sure the users of this 'commercial application' will allow that? This means that you can actually set both registery values to 4 and still load the form with the Spreadsheet control object in it. Setting the registry value to 4 is the safest it gets whereas 1 is the most unsafe. Setting the values to 4 is equivalent to clicking cancel in the popup window that is presented when loading the form since clicking cancel will load it in safe mode.
I think if we require changing the registry value to 4 it should be ok since it is basically giving the end user more security for their Excel applications than what the default security level is. I am intersested in knowing, it is possible to create a batch file that will automatically create these registry keys and if so, how would it be done? Legacy Guest.
You may call indirectly from the commandline using shell in VBA There may be a direct way as well but I do not know how. Download the zip file and extract. For testing Import "ShowWarningPrompt.
The following example adds a command button to worksheet 1. Most often, your Visual Basic code will refer to ActiveX controls by name. The following example changes the caption on the control named "CommandButton1.
Note that when you use a control name outside the class module for the sheet containing the control, you must qualify the control name with the sheet name. To change the control name you use in Visual Basic code, select the control and set the Name property in the Properties window. The following example sets the left position of the control named "CommandButton1.
Control properties that are not shown as properties of the OLEObject object can be set by returning the actual control object using the Object property. The following example sets the caption for CommandButton1. Because all OLE objects are also members of the Shapes collection, you can use the collection to set properties for several controls. The following example aligns the left edge of all controls on worksheet 1. An ActiveX control on a sheet has two names: the name of the shape that contains the control, which you can see in the Name box when you view the sheet, and the code name for the control, which you can see in the cell to the right of Name in the Properties window.
When you first add a control to a sheet, the shape name and code name match. However, if you change either the shape name or code name, the other is not automatically changed to match.
0コメント