Hello friends, hope all is well!
I keep getting the error "Unable to set visible property of the pivotitem class"
I have been trying, but don't know what editing needs to be done to see the code go thru.
I am wondering, what is needed?
Thanks a lot! in advance
Please Login or Register to view this content.
If it errors on this line...
... it could mean that all pivot items have been hidden which is not allowed. At least one must remain visible.Please Login or Register to view this content.
I don't know enough about your application to give you a definitive solution. If you know there will always be at least one match, then make all items visible before hiding the ones that don't match.
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks