Format shape reports

[Dusty_Rhodes]

Hello,

Is there a way to change the layout/look of the shape reports ? i really dislike the deafult layout for the reports with the yellow background and blue heading.

This was the only website i found that mentioned anything close to what i am after. https://blog.bvisual.net/2011/07/31/changing-embedded-visio-report-column-headers/

Most of my reports are made as visio shapes and not exported to Excel

[Croc]

A report shape is a embedded Excel object.
You can use VBA to format this object.
For example, you can change the color to white.

Code Select Expand

Sub ttt()
    Set shp = ActiveWindow.Selection(1)
    Set xls = shp.Object.Worksheets(1)
    xls.Cells(1, 1).CurrentRegion.Interior.Color = vbWhite
End Sub