Find the *username*.xlb file or excel8.xlb file for this PC (should be in
the Windows directory for xl97). Rename this file to have something other
than a .xlb extension. then try opening excel.

This file hold menu customizations. It could be corrupt or someone might
have redefined that menu item.

this is just something to try - can't guarantee it is the problem.

--
Regards,
Tom Ogilvy

"pcw" wrote in message ...
Hi guys,

When I choose "Options" in the Tools menu in Excel 97, it won't open,
instead I get a message telling
me the macro cannot run and displays the typical buttons End, Debug ....
The Personal Macro Workbook does not show any macros when I go to Tools,
Macro, Macros.

I am not a programmer so I'm in the dark about this one.

It works fine on the other pc.

Would greatly appreciate any help on this one.

pcw.