View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Harald Staff[_2_] Harald Staff[_2_] is offline
external usenet poster
 
Posts: 449
Default Add-in question: can I store default values for a form in the Add-in?

Hi Ed

It's
ThisWorkbook

HTH. Best wishes Harald


"Ed from AZ" wrote in message
...
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