Error 1004 unable to set the visible property of the pivotitem class

**4am** · 02-02-2012, 04:41 PM

Got some great code help from someone here yesterday and it worked fine. The code works great the first time I run it. But if I try to make a different selection in the drop down, it errors out (Error 1004 unable to set the visible property of the pivot item class)

If I close the workbook without saving and reopen, it will work one time.

Please Login or Register  to view this content.

**jomili** · 02-03-2012, 10:41 AM

4am, can you post your workbook so we can see it in action?

**4am** · 02-07-2012, 12:33 PM

I wish I could! Company policy, can't do it. Plus, it's 54mb! I am unsure of how to handle this issue, but I guess I will figure it out... Thank you

**jomili** · 02-07-2012, 01:28 PM

The error you mentioned means it can't find the value of your dropdown selection among the pivotitem choices. Try putting

Please Login or Register  to view this content.

at the top of the module to make it non-case sensitive. This will ensure that whether you choose "a" or "A" that the correct value will be chosen. Without that option an error such as you're describing could happen.

I've posted a new sample workbook, tested to ensure it will work no matter what the selection. Give it a whirl (go to Sheet 1)

**4am** · 02-23-2012, 10:40 AM

YOU Jomili are a GENIUS! Thank you so much you have saved the day!

**jomili** · 02-23-2012, 10:46 AM

Well, much as I appreciate the sentiment, I'm only passing on what kind souls have passed to me. But you CAN add to my repution if you'd like; that wouldn't bother me much.