Configuring pivotem.visible

Asked 2 months ago, Updated 2 months ago, 2 views

pivotitem.visible appears as integer during debugging.true, false
cannot be configured.excel VBA 2010


2022-09-30 14:26

1 Answers

I found something that seems to be an answer on an overseas site.
Please forgive me for writing without quoting.Thank you.

Occurs when the data specified in pivotfield is in date format.
This seems to be especially true for non-US locales.

A column of another name is created to convert the target data into data of a character string yyyy/mm/dd.
Use the alias pivotfield you created.
You will be able to set true and false to pivotem.visible.

The part where pivot.visible appears in the IDE does not change.

2022-09-30 14:26

If you have any answers or tips

© 2022 OneMinuteCode. All rights reserved.