Pivot table comma style.

You've got two lines on one line there which won't work. There's no point applying a comma style to anything other than the data range so you could use:

Please Login or Register  to view this content.

Your code would be a lot neater if you used a variable, or With statement, for the pivot table object, by the way.

I cleaned up the code a bit as rorya suggested. and put in his change also
It looks like recorded code (which is fine) with all those linebreaks dating back to times 80 characters was all a screen could handle..

linebreaks in the code can be usefull for real long statements, but indentation on those lines and allowing more characters on 1 line can make code a lot more easy to read.

also maybe this page (one of many) might help you in the last part to use loops to hide details of a lot of pivotitems
https://www.contextures.com/xlPivot03.html

HTML Code: