Show/Hide Pivot Fields

H

hce

Dear All

I went to Debra's website and it was amazing with the tips... I was
looking in particular the pivot tables - to hide/show fields codes...
When I tried Debra's code in my file, the fields were still not
visible... I had to click on the checkbox or the field list to make
them show all...

I am using Excel 2003...Is that the reason why? Would you also by any
chance know how I can turn on/off the "Show All" by code? I would
really appreciate your advice here...

Cheers
 
Top