Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am using macro to adding dimensions to pivot table dynamically, then use SetPixWidth method to set column width of pivot table, and it is working correctly in QV desktop. However, it doesn't work in access point. See below (SBSMID is not added by macro), all columns are narrowed down. Anyone knows how to solve the problem?
set chart = ActiveDocument.GetSheetObject("CH02")
for i=0 to ubound(boxvalues)
chart.SetPixWidth i,60
next
Hi,
Not all macros are supported in AJAX view. Try the IE plugin and check.
Regards,
Kaushik Solanki