I have a UDF that I want to use to update the .visible property for each item in a pivot table. The function runs without returning an error, but the pivot table is not updated. I put the same code into a macro and steped through it, and it works great. I also tried calling the macro (which worked by itself) from the function, and it again ran without error and without updating the pivot table.

Is the .visible property not available in UDF's? Any thoughts?


Please Login or Register  to view this content.