Don't ignore Gary's suggestion NOT to store data in the add-in.
- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/
On 9/27/2010 3:13 PM, Ed from AZ wrote:
Yes. You just need to save the addin anytime users make changes to
those defaults.
Thank you for the response.
Is there a Userform.Parent or similar that gets the add-in workbook?
I looked, but I couldn't find such a thing.
Could build a string from the ground up with the add-in name if I have
to.
It would be easier if there was a simple property.
Ed