List of Available TAGATTR?

[JeffMeyers]

Hello,

  I work in PROC REPORT with ODS EXCEL a lot and was curious if there is a current help page somewhere that simply lists all of the attributes that can be changed with the TAGATTR style option?   I've searched a lot but haven't found anything.

[ballardw]

---

@JeffMeyers wrote:

Hello,

  I work in PROC REPORT with ODS EXCEL a lot and was curious if there is a current help page somewhere that simply lists all of the attributes that can be changed with the TAGATTR style option?   I've searched a lot but haven't found anything.

---

Probably because TAGATTR stuff passes instructions to the receiving program to use that program's options. So you have to know the receiving program options and the syntax involved.

So you would be looking at EXCEL documentation.  I think if you search this forum for TAGATTR you will examples where people place formulae into cells as well as the relatively minor numeric formatting choices that are common.

[PaigeMiller]

You can follow these instructions to see what TAGATTR= options are available for ODS TAGSETS EXCELXP, most of the option (maybe even all of the options) will also be available for ODS EXCEL

[JeffMeyers]

This page was helpful, thank you. I was hoping to find a tagattr that could turn the Locked part of a cell off/on. My company wants to make an Excel sheet that has some columns not editable and some that are.

[PaigeMiller]

---

@JeffMeyers wrote:
This page was helpful, thank you. I was hoping to find a tagattr that could turn the Locked part of a cell off/on. My company wants to make an Excel sheet that has some columns not editable and some that are.

---

Better you should have mentioned what you really want in your first question. In any event, I do not know the answer.