I have an Excel 2000 file that I converted to Excel 95/97 format. On
the sheets (NOT "dialog" sheets, just normal!) I have used several
command buttons (non-dialog buttons), dropdowns, etc..

When I open the file in Excel 97 the buttons, dropdowns, etc have
changed to (it seems) dialog-related buttons.  How do I know?  When I
click on the button it puts handles around the button and there is no
way to click the button.  (I am in perpetual design mode it seems.)  In
addition, when I goto the VBE all of my code that resided in the sheets
are GONE!  The only code left is the one in the modules.

Are these known conversion issues?

Any ideas on how I can fix this?

Thanks in advance,
Robert

Sent via Deja.com http://www.*-*-*.com/
Before you buy.

Thank you John!

Rather than converted the XL file to version 95, I converted it to 97 (from
2000).  It works great!  Thanks for your help!

Robert

Robert,

Either you mean that you converted the file to Excel 5/95 format and opened
it in
Excel 97, or that you converted to Excel 5/95 & 97 dual format and opened it
in
Excel 95.

These are known conversion issues. There was a major change in Excel 97 with
the
introduction of class modules supporting event procedures and ActiveX
controls.

Excel 5/95 format does not support ActiveX controls (from the Control
Toolbox
toolbar) and does not support class modules (such as those behind
worksheets), so
ActiveX controls are converted to pictures and the class modules disappear.
Also,
there is no such feature as Design Mode in Excel 5/97.

If you want controls that work in both formats, you need to use the controls
from
the Forms toolbar,

John Green (Excel MVP)
Sydney
Australia

Please post all replies to NewsGroups

(buttons, dropdowns, modules)

Robert,

Either you mean that you converted the file to Excel 5/95 format and opened it in
Excel 97, or that you converted to Excel 5/95 & 97 dual format and opened it in
Excel 95.

These are known conversion issues. There was a major change in Excel 97 with the
introduction of class modules supporting event procedures and ActiveX controls.

Excel 5/95 format does not support ActiveX controls (from the Control Toolbox
toolbar) and does not support class modules (such as those behind worksheets), so
ActiveX controls are converted to pictures and the class modules disappear. Also,
there is no such feature as Design Mode in Excel 5/97.

If you want controls that work in both formats, you need to use the controls from
the Forms toolbar,

John Green (Excel MVP)
Sydney
Australia

Please post all replies to NewsGroups

(buttons, dropdowns, modules)