Excel 2000 Workbook close button hides instead of close

[Steven Robinson]

We received an excel file in email. When we click the Workbook close
button (the X) it hides the work book instead of closing it. When we
unhide it, something changes and the close button works as normal, but
we are asked to save changes even if we don't make any.

 

[Bill Lunney]

Looks like there is some code in the background doing something or other.

I'd check the workbook code, particulary the Workbook_BeforeClose event.

It is more likely some code or functions are changing the worksheet contents
than a bug in Excel.



--
Regards,


Bill Lunney
www.billlunney.com

 

[Steven Robinson]

I thought of this too, but there is no code in the Workbook section,
or any of the worksheet sections. Could it be hidden in a cell
somewhere? Is there hidden code in spreadsheets that I have to "turn
on" to view?

 

[Bill Lunney]

There are a few things which could be the cause

- Add-in code
- Workbook code (worksheet, modules)
- Personal workbook code

--
Regards,


Bill Lunney
www.billlunney.com