Hello Every body,

I have been using the MS Excel long time ago in developing some software dealing with tax and financial issues whereas I used to develop some VBA Macros to process various calculations and print outs. VBA Macros are actually activated using Command buttons located in different sheets of the workbooks.
I understood that under Excel 2007 if a workbook containing Macros has been initially saved as "Excel Workbook" and not as "Excel Macro Enabled Worksheet", most of the macros (not All) are deactivated; which necessitate their re-selection from the "Declarations" part of the VBA project and the renaming of the related Macro in the "Properties" part of te CommandButton.

Some time ago, when I tried to shift and process my software developed under Excel 2003 or Excel 2007 to Excel 2010; to my surprise, I noticed that whenever I specifically activate under Excel 2010 Only a Print Macro with a Print Preview option, All Macro Buttons located in the same worksheet will disappear without having the chance to retrieve them.

Appreciate any help or hint with all my thanks.