Thank you. I will review your approach above. Meanwhile, before reading your response, I ended up with what you see below. The problem is in red, wher...
Just to close the circle on this... I consolidate forms. The file size shrunk considerably. Works very well. Thanks for the recommendation.
THANK YOU! It was right there and I missed it. And... yes, I am trying to get better (and more thoughtful) about creating shareable sample files. ...
I'm revising this reply to correct an error. I thought the problem went away with time and magic, but it didn't. So I now have four pivot tables (ART,...
Thanks. I created a pivot table on a sheet called "Droplists." The first row of data is in $AB$7. So it's "Droplists!$AB$7". The data in the pivot ...
Buttons: You advised that these lines should NOT be in sheet modules, but the buttons to which they refer are on the sheet, not on a form. For now,...
Working on form consolidation now.
I got the code to work except for one issue... Sub ProtectThisSheet() If Not AddProtection(ActiveSheet.Index) Then MsgBox "Failed to protect...