$$Excel-Macros$$ Re: Macro Pivotable

2010-01-20 Thread Anil
Hi WKH8919, I would like to see the recorded macro code. Regars, Anil On Jan 20, 2:52 pm, WKH8919 worawat...@gmail.com wrote: Hi I just start to learn about macro and need expert to advise. Now I have pivotable and I record macro that will select 2 pivotItems from pivotfields but some time

Re: $$Excel-Macros$$ Re: Macro Pivotable

2010-01-20 Thread worawat kh
?Hi Anill , Sorry for late reply , below is macro code record. Range(C8).Select With ActiveSheet.PivotTables(PivotTable1).PivotFields(Transaction Type) .PivotItems(Accept).Visible = False .PivotItems(Return to Receiving).Visible = False .PivotItems(Return to