tab color in ODS

omega1983 — Wed, 25 Sep 2013 01:24:46 GMT

ODS TAGSETS.ExcelXP

options(sheet_interval='none'

default_column_width='8'

sheet_name="75-"

center_horizontal="no"

Orientation='Landscape'

embedded_titles='No'

fittopage="No"

blackandwhite="No"

Embedded_Footnotes='Yes'

autofit_height="Yes"

tabcolor="red");

Can tab color be used in exel XP I am getting unrecognized message. I want the label on a tab to be red

Re: tab color in ODS

Cynthia_sas — Wed, 25 Sep 2013 16:26:28 GMT

Hi:

This is probably a question for Tech Support. I do not believe there is a way to change the tab color with SAS, ODS and Tagsets.ExcelXP. I believe you do tab color changes in Excel with a popup window. SAS, generally, has no way to change popup windows. Another example of this limitation is adding table level style to the sheet -- in Excel, this is done using the pull-down menus inside Excel. SAS does have a way to change table style using ODS style templates, but NOT the same as using the Excel pull-down menus.

cynthia

topic Re: tab color in ODS in ODS and Base Reporting

tab color in ODS

Re: tab color in ODS