Security Warning upon Save: This document contains Macros...

[syswizard]

Tried everything to remove this warning message that occurs upon a Save.
When I tried to export the worksheet to a new workbook, all of the styles changed.

[HansV]

What type of workbook is this? .xls, or one of the newer types .xlsm / .xlsb?

[syswizard]

Hans: xlsx
I think the export idea will work, but how do I get the styles to be the same ?
Everything changed....fonts, colors of cells, etc.

[HansV]

A .xlsx workbook shouldn't contain macros, so it's weird that you'd get a warning about macros. Are you sure that it's a .xlsx workbook?

[HansV]

Try the following:
- Open the original workbook (the one that displays the warning).
- Open the new workbook.
- On the Home tab of the ribbon, in the Styles group, click Cell Styles > Merge Styles...
- Select the original workbook in the 'Merge styles from' list, then click OK.

[syswizard]

Hans - there are no macros or VBA coding in the XLSX document....very strange.
The merge styles procedure did not update the new workbook's styles using the old one's.
This is very strange...
I tried this fix as well...to no avail:
https://support.microsoft.com/en-us/kb/286394

[Rudi]

Out of interest, have you checked if your *.xlsx workbook has any empty modules in the VBE.
Press ALT+F11 and verify if there are any blank modules in the Project Explorer window; and if so, right click on them and choose to remove.
(I do notice that stray modules get removed automatically in my Excel, but I'm not sure if this is native or if its a VBE add-in doing it??)

If you choose to pursue the export process, how about trying a plain copy and paste process for each sheet from the source workbook to a blank target workbook. When you paste, choose paste with source formatting. If this does not bring in the colour palettes you might try saving the theme in the source file as a *.thmx file (Page Layout Ribbon, Themes, Save Current Theme) and then in the target workbook, in the same command, browse for the saved theme to import it again.

[syswizard]

Creating a new workbook didn't work either....when I selected the source worksheet and copied....
it created the same purple-orange garish style.

[syswizard]

That worked !! Saving the thmx file, and then opening it in the new workbook did the trick !
Thanks much Hans....simply excellent support from this site !!
This was most definitely a subtle bug in Excel 2010.

[HansV]

It was Rudi who suggested exporting/importing the .thmx file!

[syswizard]

Thanks Rudi !!!