Not working excel with VBA

I enable administrator built in account and when logged in as other user which has also administrator rights, my excel with VBA is not working properly, if i logged in as Administrator its working fine. What can i do so my other user will also use excel just like administrator without any problem?

Can any body help me,
I enabled all macros in macro setting by going through File->Options -> trust center-> trust center setting

Thanx for reply, i have already done these things as mentioned in this page, but problem has not solved yet.
Before enabling administrator account it was running fine, but after enabling admin a/c other user is not able to do work in VBA used excel sheet..........

hello
I have an Excel VBA macro (office 2010), he worked on the Platform (Windows XP – 32), but after his migration to another system (Windows 7-64) it gives me the following compilation error: “project or library not found”
I tried to change the location of the dll used to the folder: Windows \ SysWOW64, but it did not work, when I tested step by step I found that the source of the error is the property : EXTRA.System. ActiveSession. Screen

Here's the code where I have the problem:

Code:

'Modules sur la recherche de Contrat
 
 
Public Declare Function GetUserName Lib "advapi32.dll" Alias "GetUserNameA" _
   (ByVal lpBuffer As String, nSize As Long) As Long
 
   'Public Declare Function GetUserName Lib "C:\Windows\SysWOW64\advapi32.dll" Alias "GetUserNameA" _
   '(ByVal lpBuffer As String, nSize As Long) As Long
 
Global g_HostSettleTime%
 
 
Public Sub Recherche_contrat()
 
Dim Sys As Object, Sess0 As Object, MyScreen As Object, MyArea As Object
Dim tmp$
 
   Set Sys = CreateObject("EXTRA.System")   ' Gets the system object
   g_HostSettleTime = 200     ' milliseconds
   Set Sess0 = Sys.ActiveSession
   'MsgBox ("it's work ")
   Set Myscreen0 = Sess0.screen  'ßthis is exacly the  source of problem
End Sub

If anyone can help me I would appreciate His response.