Solved

Excel Module error when opened or exited

Posted on 2012-04-12
1
1,519 Views
Last Modified: 2012-04-13
Hi,
One of our users updated their PC yesterday and after the reboot everytime he opens excel he gets the following error message with the title Micrososft Visual Basic;
"Compile error in Hidden module: modMain"
I have read that it's an Adobe problem and following http://support.microsoft.com/kb/307410
hasn't helped. In fact i have removed the Adobe add on altogether.

When clicking help i get the following message;


Compile error in hidden module: <module name>
A protected module can't be displayed. This error has the following cause and solution:
•      There is a compilation error in the code of the specified module, but it can't be displayed because the project is protected.
Unprotect the project, and then run the code again to view the error.


Any ideas greatly appreciated.

Thanks
0
Comment
Question by:SWCG
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 1

Accepted Solution

by:
SWCG earned 0 total points
ID: 37837299
Hi,
Sorry found the solution i deleted all the .xla files in the startup and it worked. Just need to find out if needed those files now though :)
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question