Skip to Content

Table Grid in Bex Analyzer / Changing color

Hi Experts,

i created a workbook and would like to customize the ouput of the table grid so that after refreshing the color remain.

I would not like to color the cells manually. I would like to change in the code in VBA or somewhere the code centrally.

Is there a possibility to change it?

I read somewhere it is possible to change the query template. How to do it?

By chnaging the BW Style.css for the web template is it possible to apply it to the query ? how?

Thank you in advance

Cheers

Gilo

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jun 23, 2010 at 05:31 AM

    You can change the default workbook template and assign it to the workbook.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 23, 2010 at 03:41 AM

    Hi,

    As per my knowledge there is no need VBA code to fill the colour . if you have any grpah on this workbook there is a option right click you can find the option to fill the colours.

    Regards

    Sivaraju

    Add comment
    10|10000 characters needed characters exceeded

    • Hi,

      thank you for replying.

      I have not graph i have a table and would like to change the Grid color, text color and cell color.

      Could we change some values in VBA and where?

      Thanks