Macro Error

  • Thread starter Thread starter Kyle Konopasek
  • Start date Start date
K

Kyle Konopasek

I have Excel linked into Word to create financial
statements, but on my laptop only, I get an error message
every time I open Excel financial statements as follows:

"Microsoft Visual Basic: Compile error in hidden module:
ThisWorkbood"

I don't know what this means or how to fix. Blank Excel
spreadsheets are fine. It's only on my laptop and only
with financial statment files.

Any ideas?
 
Hi Kyle
maybe you have created a macro in this specific workbook. Try the
following:
- open your workbook (with macros enabled)
- hilt ALT - F11 to open the VBA editor
- doubleclick on the entry 'ThisWorkbook' in the left explorer window
for you workbook
- check/delete all code in this module (in the editor window)
- close the VBA editor
- save this workbook (make a backup copy prior to this)
- close this workbook and try again
 
Something that is being opened is causing trouble.

It could be an addin checked in Tools|Addins or a file in your XLStart folder
(or if you are using tools|options|General|"Alternate Startup File location", it
could be in there.)

(Not many use the alternate startup file location, so try erasing that value
from that box in excel--don't delete the real folder. If that fixed it, you're
done.)

If not, your task will be to uncheck everything in tools|addins, remove all the
files from the XLStart (and alternate startup location) and start adding things
back one by one.

And restart excel between each change--until you find the culprit.

Chip Pearson has some additional notes to help diagnose this kind of problem at:
http://www.cpearson.com/excel/StartupErrors.htm
 
Back
Top