Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

subject not trusted for specified action vba error

Status
Not open for further replies.

thazz

Programmer
Apr 18, 2016
6
IN
I have developed a macro which uses date control. When installed on the server system my macro works fine. But it doesn't work on the workstation. The issue is that my date controls are missing from the user form. When I tried to drag drop the same, I am getting the error as:

"The subject is not trusted for the specified action".

I cannot figure out what went wrong.Please help.

 
How did you set up your date control? Are you using Now or Date or the System Date or something different?

It has taken me a while to make sense of what I hear at work involving computers. There is much talk of bugs and questions about Raid.
Therefore I have come to the logical conclusion that the only way to have a properly functioning computer is to regularly spray it with Raid bug killer.
 
I have set default date to the date control in the macro in the program. This is how that date control looks like when i open at my end.

img1_gtqpjc.jpg


When I opened the form at workstation, The date controls are missing from the form as shown in below screen shot:

img2_uu2tmr.jpg


I added Microsoft date and time picker control to toolbox and then tried to drag drop it to my user form. Then I get the error as :

img3_km5ee1.gif


please help me out.[ponder]
 
Try running the code shown below. You may be suffering from a killbits issue.

If CreateObject("WScript.Shell").RegRead("HKLM\SOFTWARE\Microsoft\Internet Explorer\ActiveX Compatibility\{20DD1B9E-87C4-11D1-8BE3-0000F8754DA1}\Compatibility Flags") = 1024 Then CreateObject("WScript.Shell").RegWrite "HKLM\SOFTWARE\Microsoft\Internet Explorer\ActiveX Compatibility\{20DD1B9E-87C4-11D1-8BE3-0000F8754DA1}\Compatibility Flags", 0, "REG_DWORD"
 
Thank you.

let me see if this helps[2thumbsup]
 
When I pasted the provided code and run my application, I get the below screen

Untitled_v4opkj.png
 
Looks like you don't have sufficient rights. Try elevating the rights of your command prompt by opting to "Run As Administrator
 
Sorry, not your command prompt, as you are not running this as a script - run your VBA host as administrator
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top