Morning all, I have possibly the weirdest situation I've ever come across and
would appreciate any suggestions as to what might cause it, and any possible
solutions.

On opening a certain workbook, the following occurs:
1. Asked for "open" password
2. Asked for read/write password
3. The workbook "half" closes....

At point 3, the workbook appears to close. However, the title of the
workbook is still present at the top of the application ("Microsoft Excel -
Authorised KEI", where "Authorised KEI" is the name of the workbook.)"
There are no macros present, and security is set to Medium - not presented
with the Enable/Disable dialogue box.
The "Body" of Excel is blank.
All toolbar options that would normally be available on an open workbook are
blank.
There are no sheets visible.
Opening the VBE, the workbook name is not in the Project List on the left.
Selecting "Record New Macro" only allows the options to record in a New
Workbook or in Personal.xls
Selecting "Windows" from the main toolbar does not allow selection of the
workbook.
No options to amend Format properties are available for row/column/sheet.
No options to (un)protect sheets or workbook, share workbook etc are
available.
No options to Save/Print Preview/Print etc are available.
Same response for multiple users on different pcs.


And yet, on Task Manager the workbook shows as open, and the title of the
workbook is in the Excel application title bar...

Confused. Help?

MikeC