How to fix initializing the vba libraries 40040 error in Microsoft Excel

How to fix initializing the vba libraries 40040 error in Microsoft Excel
I want 5 members to work simultaneously on excel file. But it is possible only one person can work .when accessing this file by others its showing the error "an error occurred initializing the vba libraries 40040".Please give the solution ASAP..
Reply With Quote
#2
Old 11-01-2012
Gania Gania is offline
Member

Join Date: Nov 2010
Posts: 480
Re: How to fix initializing the vba libraries 40040 error in Microsoft Excel
There are around 3 possibilities that you can try out. First check the Excel macros names assigned to cells in a spreadsheet macros. You need to only need to open the book and stop the use macros for start being. If you had given permission to use macros to a workbook. Second the execution of macros that run are equals vba macros. Select the macro to run and from the dialog that appears by pressing F8 or click on Menu > Tools > Macro.
Reply With Quote
#3
Old 11-01-2012
Alfons Alfons is offline
Member

Join Date: Nov 2010
Posts: 410
Re: How to fix initializing the vba libraries 40040 error in Microsoft Excel
VBA recognizes objects that are declared dynamically or static, sometimes if they are incorporated as shown in code, or we forget, or you do not realize their presence days or until the conflict is at stake for the lack or nuisance to a secondary object, or even a different version. By default, I believe there are four basic references. For add-ins, I do not remember, but the same applies for self-installation, I get even do it in VBS.
Reply With Quote

If you like this post then consider sharing it with others.