Resizing a pivot column based on Field Name
 

I need to find code that will resize a column based on the pivot row's field
name.

Say I have a pivot field named "Long Name" and each time I use it for a
pivot it autofits to an enormous length. I need a macro to check each
pivotrows' name and resize it to a specific length if it matches "Long Name".
Make sense?

I know that I could just set the size to what I want and then turn off
autoformat, but this won't do because the pivot can be changed and sliced
many ways. I need a dynamic solution.

Thanks in advance to anyone who can help me out with this!!

Resizing a pivot column based on Field Name
 

Are there no solutions to this problem? I've seen similar questions posted
here before and have never seen an answer.

"cmungall" wrote:

I need to find code that will resize a column based on the pivot row's field
name.

Say I have a pivot field named "Long Name" and each time I use it for a
pivot it autofits to an enormous length. I need a macro to check each
pivotrows' name and resize it to a specific length if it matches "Long Name".
Make sense?

I know that I could just set the size to what I want and then turn off
autoformat, but this won't do because the pivot can be changed and sliced
many ways. I need a dynamic solution.

Thanks in advance to anyone who can help me out with this!!

Resizing a pivot column based on Field Name
 

If you leave AutoFormat on, the column will adjust automatically, to fit
the widest entry.

cmungall wrote:
I need to find code that will resize a column based on the pivot row's field
name.

Say I have a pivot field named "Long Name" and each time I use it for a
pivot it autofits to an enormous length. I need a macro to check each
pivotrows' name and resize it to a specific length if it matches "Long Name".
Make sense?

I know that I could just set the size to what I want and then turn off
autoformat, but this won't do because the pivot can be changed and sliced
many ways. I need a dynamic solution.

Thanks in advance to anyone who can help me out with this!!


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html