Not working excel with VBA

[mcsmba1]

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?

 

[mcsmba1]

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

 

[Ranger4]

Have a look at this MS website. There is a part about using VBA & user access that might help you. There apparently a safety feature that is incorporated to prevent unauthorised access & code being changed.

https://support.office.com/en-us/ar...in-Excel-3b5ec213-efcc-4d48-9efd-83d097397a7e

This is not something I know anything about, but I did a web search & this I thought might help you.

 

[mcsmba1]

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..........

 

[sipom]

VBA problème in windows 7

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:

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

If anyone can help me I would appreciate His response.