compile error in hidden module module1

I have use excel 2007 but error is cimpiled error module 1 please give the solution
 

Question Info


Last updated November 26, 2018 Views 9,643 Applies to:
Answer

This probably means you are running an add-in that is incompatible with Excel 2007.

 

Another possibility is that a workbook of your own has a compile error and you have protected the VBProject.  But if that were your case you would know how to correct it.

 

So, try disabling all add-ins (Office Button > Excel Options > Add-Ins).

You can then add them back in one at a time until the error is given.

 

If you would then tell us which add-in it was, it could be helpful to others who hit the same issue.

 

 

Microsoft Excel MVP, Oxford, England. www.manville.org.uk

2 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.