Step 3: Under the SHEET tab, we have a PRINT section select the Gridlines check box. Step 2: Now go to the SHEET tab under below dialogue box. Step 1: Go to PAGE LAYOUT, under this click on the little expand icon. "C:\Program Files\Microsoft Office 15\Root\Document Themes 15\Theme Colors\Office 2007 - 2010. THE SOLUTION: Page Layout -> Colours -> Office 2007-2010Īnd in VBA: ( _ This problem is not present when you are using workbooks created from scratch in Office 365, but on files created with previous versions of office, the issue is unresolved when used a later version of Office. I am using Office 365 on Win8, and these standard colours change to different shades of yellow and grey. Try copying/moving the sheet to a new workbook and see what happens, this file originates from an Office 2010 platform. I have attached a file for you to play with. This is the case even when colour pallets of both workbooks are the same. Upon doing this, all colours would change to a different theme, including the colours of charts. 
To have all contents pertaining to a sheet (including floating objects) one would have to move/copy the sheet to the new/destination workbook.
Selection.PasteSpecial Paste:=xlPasteAllUsingSourceTheme, Operation:=xlNone _
This option will only work when there are no floating objects (charts, diagrams, shapes) in that worksheet. Let's say that we are using the "Paste Special - All using source theme" option, only your data and formatting from the original worksheet would be retained, floating objects would not be copied over. I have done some troubleshooting with this, and my findings are as follows.
0 kommentar(er)
