Macro Error

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?
 
F

Frank Kabel

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
 
D

Dave Peterson

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
 
Top