Moving PivotTable Field List with Macro...is it possible?

[PP3321]

Dear Chandoo Community,

Thank you always for your help...today I have 1 problem and I want to ask your advice...

When you click on Pivot table, FieldList appears on the right side of the worksheet.
Is it possible to move this with Macro, so that everytime I open it, it appears on the left side, for example...?

I know I can show it on and off with the below code...but I wondered if I can move it left or right...

ActiveWorkbook.ShowPivotTableFieldList = True

Thanking you in advance...

 

[Chihiro]

There is no object model for PivotTableFieldList in VBA.

Only control available is the one you used to show.

Likely you will need API call to control it's position. Though I couldn't find documentation in initial search.

 

[Monty]

No idea...But interesting Question

 

[PP3321]

@Chihiro
Thank you. I think I will create UserForm to replace the Field List...