Denz,

This is a "spooky" kind of error (for me). Never sure where it comes from -
but it happens.

The first thing I do is Compile the code to see if Excel can pick up any
obvious prolems.
(Make sure that you have Option Explicit as the top line in ALL your modules
(code and worksheet).

Than get a copy of the Code Cleaner and run it on your workbook.

If this doesn't solve the problem - you'll have to dig deeper.
1. Make sure that the name of any sub is not the same as the name of
the code module.
2. Make sure that any names, variables, etc are not reserved words for
Exel. (you can check
this by putting the cursor on the word in the code and pressing F1,
if the word is safe Excel
won't be able to find anything in Help.)
3. Make sure you haven't duplicated the use of a word - 2 or more subs
with the same name, names
used more than one way. (You can dim the same word in different
modules without worrying about
duplication).
4. If you are using Public variables - make sure that you haven't
declared them any where else
in code.
5. Check any names defined in the Workbook, on worksheets, objects,
etc. to make sure there
are no conflicts.

Hopefully by this time your code and workbook are clean and the problem will
cease...

Keep us posted on your progress...

--
steveB

Remove "AYN" from email to respond
"Denz" wrote in message
oups.com...
Hi all,
Can you please help me to resolve this issue.
I have a file with links to other excel files and a small macro that
prints all the pages in the form of a report.

I have used this for the past 2 mths but this month it has suddenly
gone a funny.
After opening the file, I save it and whether I make changes or not
keep getting this error message:

Excel has generated Errors and will be closing windows.
You need to restart the program.
An error log is being created.

I tried removing the Macro and deleting all the links outside the
workbook but without success.

Many Thanks
Denz