Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.

Windows 7: Not working excel with VBA

12 Nov 2015   #1

Windows 7 Ultimate 32x
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?

My System SpecsSystem Spec
13 Nov 2015   #2

Windows 7 Ultimate 32x

Can any body help me,
I enabled all macros in macro setting by going through File->Options -> trust center-> trust center setting
My System SpecsSystem Spec
14 Nov 2015   #3

Windows 7 Home Premium 64 bit sp1

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.

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

14 Nov 2015   #4

Windows 7 Ultimate 32x

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..........
My System SpecsSystem Spec
04 Dec 2015   #5

Windows 7 Entreprise x64
VBA problème in windows 7

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:
'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.
My System SpecsSystem Spec

 Not working excel with VBA

Thread Tools

Similar help and support threads
Thread Forum
Explorer.exe keeps crashing when working in excel, word or Outlook
Dear, We have several users that are working on a Windows 7 computer but they are reporting that explorer.exe is crashing 4 a 5 times a day. I have made a dump file with the tutorial of capt. jack sparrow hope you guys could help me finding why explorer.exe is crashing. I tested the following...
BSOD Help and Support
AERO function not working for MS Excel 2007
Hi all; My Aero function seems not to be working for MS Excel 2007. AERO is working on all other apps. When launching MS Excel 2007 as a single app, the Aero function is working as shown below. However, when launching more than ONE MS EXcel 2007 file, the AERO function ceased to work for MS...
General Discussion
Microsoft Office Excel has stopped working
Hello everybody, :) One of our clients is facing this issue in excel as showing below, what came in my mind is to reinstall office. But, i would like to know if there is alternative and correct method to solve. Thank you.
Microsoft Office
Microsoft working to bring natural language, speech input to Excel
Read more at source: Microsoft working to bring natural language, speech input to Excel | ZDNet
Ms office excel 2010 symbol not working to insert on page
ms office excel 2010 symbol not working to insert on page, , all the symbols when you press " insert " symbol and the character box microsoft excel and word. what might be the issue....
Microsoft Office

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd

All times are GMT -5. The time now is 15:50.
Twitter Facebook Google+